BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Dynamic arrays are a new feature being rolled out in Excel 365. This blog explains how they work, and why they will make so many things in Excel easier.
Posted by Andy Brown on 14 February 2020
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Using dynamic arrays in Excel
With apologies to Harold Macmillan:
Or to put it another way ... get ready for dynamic arrays in Excel! This blog explains how to find out if you can use dynamic arrays yet, shows how to use them and then gives three case studies showing some of the implications of this brave new world.