If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

Find out how dynamic arrays in Excel will change your (working) life!

Part one of a six-part series of blogs

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:

"The wind of change is blowing through this software and whether we like it or not, this growth of functionality is a technological fact".

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

This blog has 0 threads Add post