Thanks you so much Asa for your help, it's great value!
On Feb 25, 12:05 am, "Asa Rossoff" 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
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 get
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
Search new 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)
On Oct 24, 4:33 am, ashish koul 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 :
http://twitter.com/exceldail
App = Nothing
Application.Calculation = 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:/
