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 formula help for calculating freight. 2
Reduce Fie Size, Speed Up Calculation 4
Search an array of sheets for an array of numbers & return count of numbers 11
Auto Change Formulas - Please Help. 2
Copy entire row from another sheet onto first sheet if a unique text matches 1
Array Formula + Indirect Reference 0
COLUMN() problem with array formula 0
Need a function to match unidentical strings 0

Top