Thanks you so much Asa for your help, it's great value!
On Feb 25, 12:05 am, Asa Rossoff a...@lovetour.info wrote:
Hi Johann,
That is another example usage of a boolean expression as a criterion. In
your example you could actually omit the -- since you are multiplying the
expression already
what about :
{=LARGE(- -($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1))}
?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
Hi Cyberspace,
I'd like to understand the meaning of -- in front of an Excel
function like :
=--sumproduct(...)
=--substitute(...)
... and other I can't recall
I know that in some programming language it's a way to decrement a
variable like i = i - 1 can be i-- or --i following the precedence of
values
Any idea?
Johann
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post
On Oct 24, 4:33 am, ashish koul koul.ash...@gmail.com wrote:
check both method 1 and method 2
Great
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
= xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
Thanks
Johann
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group