Dynamic array in Excel

A dynamic array is a formula whose results spill into as many cells as it needs, so one formula replaces a column of copied formulas.

SORT, FILTER, UNIQUE and SEQUENCE all return dynamic arrays, and the hash operator refers to the whole result.

In a model built on copied formulas, a dynamic array can look like a single cell with a block of values beside it, which is easy to misread during a review.

More definitions

Twenty-five terms a reviewer needs, each in one sentence followed by the context that matters.