Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Does anyone know if using structured table references is better for
processing time than simple cell references? For example, if I'm grabbing values based on: =VLOOKUP(Equity[[#This Row],[Date/Time]],MarketData[[#Data],[Date/ Time]:[Close]],3,TRUE)-VLOOKUP(A2,MarketData[[#Data],[Date/Time]: [Close]],3,TRUE) is that going to be any faster than: =VLOOKUP(A3,MarketData[[#Data],[Date/Time]:[Close]],3,TRUE)- VLOOKUP(A2,MarketData[[#Data],[Date/Time]:[Close]],3,TRUE) or am I just wasting my time reading/typing that all out? Keep in mind that I have 104,000+ rows, and every second I can save counts. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel processing | Excel Worksheet Functions | |||
Processing Data | Excel Worksheet Functions | |||
data processing | Excel Discussion (Misc queries) | |||
Pivot Table Processing | Excel Discussion (Misc queries) | |||
Conditional Processing | Excel Discussion (Misc queries) |