Dynamic Arrays
NEW FUNCTIONS
Dynamic Arrays are built into all Excel functions and are available with no action required by the user. The following are the specific new Dynamic Array functions added in the 2019 time frame.
=FILTER
There are exercises in this website that show how to use each of these new functions.
How do you know if your version of Excel has been updated for Dynamic Arrays? Here’s a quick way: type a column of names or any text, say 5-10 rows of data.
In a separate column type =SORT( then highlight the range of names and press Enter. If your data is sorted, Dynamic Arrays are available to you. Change one of the names in the first column and note the Sort column is updated upon pressing Enter.
The Dynamic Arrays functions listed above are the new Excel. Other Legacy type Excel feature are supported by Dynamic Arrays as well.
The SORT and all the other Dynamic Array functions will be discussed in detail in the pages in this section of the website and with the supporting practice files.
A quick comment on our Solutions approach: Teaching or demonstrating an Excel function is meaningless unless the user can relate to how it applies to their own real world. We are proud of our Solutions approach that uses examples that actually do apply the real world. These come from 30 years of Excel consulting and direct from current users.
Excel Practice Files:
Each page in the menu to the left has, or will have, complete discussions on the feature and a link to one or more practice files. Those same files are available here (listed all in one place)
Other useful files to see how Dynamic Arrays work with Legacy features:
.
Author: Jim Colville
Date: 5/18/2022 – Updated: 6/9/2023