On Simon’s blog, sam comments regarding OFFSET vs. INDEX:
There is a huge performance hit.
…
You will notice hardly any difference in the Calculation times
But the recalculation times will significantly different in case of OFFSET- to the tune of 25-30 times slower compared Index.
I’ve heard this many times before, but I guess I’m just lazy. I’ve [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/01/07/new-years-resolution-no-more-offset/
Posted
Jan 07 2010, 05:52 PM
by
Daily Dose of Excel