Forum Discussion
excell
- That is great , It has solved my problem thank you for your help
You probably use many whole column matrix formulas
Little details.
Your specified matrix formula could be reduced to: {= MAX ((Table2! O: O = B3) * Table2! F: F)}
Test this with = MAX ((Table2! O1: O40000 = B3) * Table2! F1: F40000)
Instead of including the whole column in the formula, add the range.
Instead of (as above) Table2! O: O
Test (as above) Table2! O1: O40000
Here is an optimization for the calculation time:
if the data source (table1 $ A: $ E) contains a lot of data, then
Table1 $ A: Sort $ E according to column A in ascending order on the whole formula.
Additional Infos: How to troubleshoot "available resources" errors in Excel
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Thank you Nikolino for your reply, I really do not understand your reply. All I would like to know is how to stop this popping up on my spread sheet,
- With the existing Aray formulas in your file, instead of searching through the entire column, you could restrict them to a more restricted area with the formula.
This means that it does not have to calculate all cells in the column (s).
The amount of data is decreasing.Thank you I have fixed the problem