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.
- Using dynamic arrays in Excel (this blog)
- Can I use dynamic arrays?
- Introducing dynamic arrays
- Filtering and sorting data
- Two more functions: RANDARRAY and SEQUENCE
- Implications of dynamic arrays
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.
For other new functions introduced recently into Excel, see my separate blogs on XMATCH / XLOOKUP and on IFS, SWITCH and other new functions.
- Using dynamic arrays in Excel (this blog)
- Can I use dynamic arrays?
- Introducing dynamic arrays
- Filtering and sorting data
- Two more functions: RANDARRAY and SEQUENCE
- Implications of dynamic arrays