As an enhancement to Excel’s calculation engine, the Dynamic Arrays functionality enables a single formula to produce results that expand into other cells, as demonstrated in the SORT example below.

While dynamic arrays offer numerous advantages, they have limitations when used with Excel tables. For example, tables do not automatically expand with dynamic arrays.

Learn how to use Excel’s dynamic array formulas to automate data pairing, save time, and unlock new insights in your analysis. Excel arrays ...

Select the array of cells that you want to collapse and expand. Click "Data" in the Excel ribbon. Click "Group" in the ribbon's Outline section to open a pop-up menu.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP().

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells ...