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.