Dynamic array

Excel glossary definition

A formula that returns multiple values which spill into adjacent cells.

Definition

Available in Excel 365 and Excel 2021. Functions like FILTER, SORT, UNIQUE, and SEQUENCE return arrays that automatically populate the cells below or to the right of the formula cell.

Back to Excel glossary