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.