Choice of function

[JackDanIce]

Hi,

Is there a list that tells me what functions execute faster than others or how can I work this out for myself?

A problem posted yesterday asked for a YES or NO output if a value existed in a range or not. Two solutions were suggested:

=IF(ISNUMBER(MATCH(B1,$A$1:$A$100,0)),"Yes","No")

and

=IF(COUNTIF($A$1:$A$100,B1)>0,"Yes","No")

And, similarly, I know how INDEX(MATCH for large data sets is (can be?) faster than VLOOKUP for the same result

So curious to know when using functions, if my sole objective was fastest calculations/execution, what to consider and how?

Thoughts please, thanks,
Jack

 

[T. Valko]

Valko - just don't ask for tongue! I'd join in with you, but I'm too busy finding quotes from comedies I like. It's just the way it rolls!

 

[JackDanIce]

Ha ha, great NEW signature, like it!