Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation Efficiency (Speed)?
It would be far more efficient to include the reference/link than to
repeat the INDEX/MATCH functions. In article , Ken wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation Efficiency (Speed)?
Thank you ... I am on it ... Kha
"JE McGimpsey" wrote: It would be far more efficient to include the reference/link than to repeat the INDEX/MATCH functions. In article , Ken wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Speed | Excel Worksheet Functions | |||
Speed up calculation of a worksheet that contains formula | Excel Worksheet Functions | |||
Calculation speed issue | Excel Discussion (Misc queries) | |||
Calculation Speed | Excel Discussion (Misc queries) | |||
Maximum Calculation Speed | Excel Worksheet Functions |