COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
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.

  1. Using dynamic arrays in Excel (this blog)
  2. Can I use dynamic arrays?
  3. Introducing dynamic arrays
  4. Filtering and sorting data
  5. Two more functions: RANDARRAY and SEQUENCE
  6. 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.

This blog has 0 threads Add post