| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Speed of array formula
Hello All
I have several sheets with a high column and row count, and takes about 3 minutes to calculate. Each sheet has a column of unique numbers for referencing common rows of data between each sheet using array formulas (formuli). The reference column is always to the right of all the data (column 300ish). Would Excel "think" quicker if the reference column on each sheet was down the left side of the data (column 1). I am trying to speed up the file and any improvements are worth considering. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Speed of array formula
Look here for performance tips:
www.decisionmodels.com -- Kind regards, Niek Otten Microsoft MVP - Excel "Cresta" wrote in message ... Hello All I have several sheets with a high column and row count, and takes about 3 minutes to calculate. Each sheet has a column of unique numbers for referencing common rows of data between each sheet using array formulas (formuli). The reference column is always to the right of all the data (column 300ish). Would Excel "think" quicker if the reference column on each sheet was down the left side of the data (column 1). I am trying to speed up the file and any improvements are worth considering. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc Speed & Formula simplification | Excel Discussion (Misc queries) | |||
| Excel 2002 : Is there any speed fill formula ? | Excel Discussion (Misc queries) | |||
| Worksheet speed with array formula | Excel Discussion (Misc queries) | |||
| Speed up calculation of a worksheet that contains formula | Excel Worksheet Functions | |||
| Can you speed UP drag speed? | Excel Discussion (Misc queries) | |||
Hybrid Mode
