| 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 ?
Hi,
Try both on your data and see which one is faster, they should be about the same. -- Thanks, Shane Devenshire "colwyn" wrote: =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 Shane. I'm in the process of building the spreadsheets so
thought I'd ask first. Colwyn. On Oct 1, 3:31*pm, ShaneDevenshire wrote: Hi, Try both on your data and see which one is faster, they should be about the same. -- Thanks, Shane Devenshire "colwyn" wrote: =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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OFFSET, INDEX, MOD.. ?? | Excel Discussion (Misc queries) | |||
| Should it be Index or Offset ? | Excel Programming | |||
| Index, Vlookup, Offset | Excel Worksheet Functions | |||
| Want to offset found value using Index | Excel Worksheet Functions | |||
| Index, Match, Offset? Not sure which to use | Excel Worksheet Functions | |||
Hybrid Mode
