| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
