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:
Continue reading
This content is not freely available. To access 'Automating changes in Excel' you need to be one of the following:
-
ACA student
-
This content is available to ACA students. If you want to start the ACA qualification there are several routes you can take
-
ICAEW member
-
Gain access to world-leading information resources, guidance and local networks. 98% of the best global brands rely on ICAEW chartered accountants.