Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Should it be Index or Offset ?
=INDEX('2007'!A:N,K2,14) =OFFSET('2007'!A1,K2-1,13) Anyone know which of the above works fastest when applied down 50,000+ rows of several spreadsheets? Thanks. Colwyn. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Should it be Index or Offset ?
INDEX
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "colwyn" wrote in message ... =INDEX('2007'!A:N,K2,14) =OFFSET('2007'!A1,K2-1,13) Anyone know which of the above works fastest when applied down 50,000+ rows of several spreadsheets? Thanks. Colwyn. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Should it be Index or Offset ?
Thanks Bob. Happened to get another answer also and it may help others
so will post it here. Colwyn. "The OFFSET function is "volatile"....meaning that it recalculates whenever any cell in the workbook calculates. The INDEX function is non-volatile and only recalcs when one of it's referenced values changes. Consequently, INDEX is faster. The list of volatile functions includes: RAND, NOW, TODAY, OFFSET, CELL, INDIRECT" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OFFSET, INDEX, MOD.. ?? | Excel Discussion (Misc queries) | |||
index and offset functions | Excel Worksheet Functions | |||
Looking in one col, counting in another. OFFSET?INDEX? Help!! | Excel Worksheet Functions | |||
Lookup, Index or Offset | Excel Discussion (Misc queries) | |||
Index, Match, Offset? Not sure which to use | Excel Worksheet Functions |