What are dynamic arrays in Excel? Dynamic arrays are new to Excel and are available in Microsoft 365 (formerly called Office 365). Excel formulas that return a set of values, also known as an array, return these values to neighboring cells. This behavior is called spilling. Formulas that can return arrays of variable size are called dynamic array formulas. Spill means that a formula has resulted in multiple values, and those values have been placed in the neighboring cells.

• UNIQUE – extracts unique items from a range of cells.
• FILTER – filters data based in the criteria you define.
• SORT – sorts a range of cells by a specified column.
• SORTBY – sorts a range of cells by another range or array.
• RANDARRAY – generates an array of random numbers.

Learn with YouTube

Here’s a video by Leila Gharani called Excel Dynamic Arrays (How they will change EVERYTHING!).