How to define and select the last (bottom) number in a column?

  • Thread starter Thread starter Guest
  • Start date Start date
I find that very surprising. My formula uses 4 function calls and Gary's
uses 1... one would think mine would have been much slower. Kind of makes me
think LOOKUP is not a very efficient function underneath it all. Thanks for
running the test; I really appreciate it.

Rick
 
I find that very surprising.

I was surprised too. I thought SUMPRODUCT would be faster.
 
T. Valko said:
I was surprised too. I thought SUMPRODUCT would be faster.
Click to expand...
....

The SUMPRODUCT on its own is almost certainly faster, but all the
stuff in the MAX call takes time to process.

Another academic question would be how an array formula like

=INDEX(rngA,MAX(IF(rngB<>"",ROW(rngB))))

would compare.
 
Harlan Grove said:
...

The SUMPRODUCT on its own is almost certainly faster, but all the
stuff in the MAX call takes time to process.

Another academic question would be how an array formula like

=INDEX(rngA,MAX(IF(rngB<>"",ROW(rngB))))

would compare.
Click to expand...

It compares favorably when the start of the range is row 1:

http://img502.imageshack.us/img502/5467/calctimes11ng0.jpg

But it's slower, as is SUMPRODUCT, when you need to calculate the row
offset.
 
Back
Top