LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Calculation Efficiency (Speed)?

Excel2003 ...

3 WorkSheets ... WS1, WS2 & WS3 ... Cols A:F ... all contain the same
respective Values returned by the same Index/Match Formula pegged to Cols in
WS4. This the result of copying WS2 & WS3 once I had WS1 working.

Rather than leaving the Index/Match Formulas on WS2 & WS3 ... Is it easier
for Excel to calculate if I use Index/Match Formula on WS1 only ... & then
use "equal" Formulas (Links) from WS2 & WS3 to WS1 as in options below:

1: WS1 Index/Match WS4 ... WS2 Index/Match WS4 ... WS3 Index/Match WS4
2: WS1 Index/Match WS4 ... WS2 Equal Links WS1 ... WS3 Equal Links WS1
3: WS1 Index/Match WS4 ... WS2 Equal Links WS1 ... WS3 Equal Links WS2
4: or other?

What is the most efficient way to say up ... for Excel to calculate this
condition?

Thanks ... Kha




 
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
Calculation Speed Jay Excel Worksheet Functions 1 April 18th 07 06:36 PM
Speed up calculation of a worksheet that contains formula vennila Excel Worksheet Functions 2 April 24th 06 01:42 PM
Calculation speed issue Steve M Excel Discussion (Misc queries) 4 January 14th 06 02:18 AM
Calculation Speed TJ Excel Discussion (Misc queries) 2 September 22nd 05 04:38 PM
Maximum Calculation Speed Ola Excel Worksheet Functions 3 February 19th 05 02:38 PM


All times are GMT +1. The time now is 06:47 AM.

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

About Us

"It's about Microsoft Excel"