#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel processing Wendy Elizabeth Excel Worksheet Functions 1 June 18th 07 05:17 PM
Processing Data dan Excel Worksheet Functions 0 August 13th 06 02:33 AM
data processing Youyou Excel Discussion (Misc queries) 1 November 19th 05 10:42 AM
Pivot Table Processing Daniell Excel Discussion (Misc queries) 4 November 4th 05 07:14 PM
Conditional Processing Daniell Excel Discussion (Misc queries) 3 August 26th 05 12:45 AM


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"