Excel tips: how to do dynamic arrays (subscription version)

An update to the subscription version of Microsoft Excel has the LAMBDA function, which addresses a key challenge when using dynamic arrays.

To explain more about this functionality is Excel expert, Neale Blackwood CPA.

Listen now

Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes three podcasts, providing commentary and thought leadership across business, finance, and accounting:

• With Interest
• INTHEBLACK
• Excel Tips

Search for them in your podcast service.

You can email the podcast team at [email protected]

And you can read more of Neale’s Excel articles for INTHEBLACK online.