T
T. Valko
I find that very surprising.
I was surprised too. I thought SUMPRODUCT would be faster.
I was surprised too. I thought SUMPRODUCT would be faster.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to define and select the last (bottom) number in a column?
H
Harlan Grove
....T. Valko said:I was surprised too. I thought SUMPRODUCT would be faster.
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.
D
Don Guillett
ANY number larger than any number in the column would do.
T
T. Valko
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.
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.