Forum Discussion
How to avoid calculating the same value over and over again - performance best practice
Suppose you want to compare each cell in a range with the total average.
What is the best solution in terms of performance?
- Place the cell with the Average formula to the left or top
- Place the cell with the Average formula to the right or below
- No need to load the Average to a dedicated cell.
- A Lambda wrapper for the Average does the trick.
- Other
Many thanks.
9 Replies
Addendum:
I am convinced that the helper cell location is crucial for overall performance.
Refer to:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructionsAddendum:
I am convinced that the helper cell location is crucial for overall performance.
Refer to:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructionsI am convinced that the helper cell location is crucial for overall performance.
Refer to:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructionsI am convinced that the helper cell location is crucial for overall performance.
Refer to:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructionsThe LET function first, then wrapping that in a LAMBDA.
But I say that without actually seeing what you're working with. Calculating the average as a single dedicated cell could also work; I can't imagine that the placement of that cell, per se, would make a difference.
Thank you for your prompt reply.
By contrast to your answer I am convinced that the helper cell location is crucial for overall performance.
Refer to:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructionsLet's leave this ticket open for a while to see whether other contributions come from those who care about Excel overall performance.
I am convinced that the helper cell location is crucial for overall performance.
Refer to:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructionsThank you for your prompt reply.
By contrast to your answer I am convinced that the helper cell location is crucial for overall performance.
Refer to:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructionsLet's leave this ticket open for a while to see whether other contributions come from those who care about Excel overall performance.
