ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Processing Time (https://www.excelbanter.com/excel-worksheet-functions/151097-processing-time.html)

[email protected]

Processing Time
 
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.



All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com