Speed of array formula

C

Cresta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel A CountIF question... I think 2
Reduce Fie Size, Speed Up Calculation 4
changing multiple column references in a formula 5
Help with a Formula Please 4
Auto Change Formulas - Please Help. 2
Relative Range Reference in a sumifs formula 6
using the =page! feature to transpose a row to column 0
Conditional array not working with pivot table data - what am Imissing?? 1

Top