ICAEW.com works better with JavaScript enabled.

Continue reading

Automating changes in Excel

Excel tips on automatic processes from our expert Simon Hurst.

We can make this a little more elegant using the recently introduced LET() function. This function allows you to allocate up to 126 different calculations to named ‘variables’, which can then be used in the final argument that performs the overall calculation. 

To achieve this, we can use Dynamic Arrays to refer to entire Table columns: