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 ce...
The 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-obstructions
Let's leave this ticket open for a while to see whether other contributions come from those who care about Excel overall performance.