In the Excel user interface you can use the #-operator to reference the output range of a dynamic array formula. This operator is not a part of the OOXML-standard.

Learn how to fill blank cells in Excel effortlessly with dynamic array functions like SCAN, REDUCE, and LAMBDA. Handle Excel blank cells with ...

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.

Cell E5 contains the dynamic array Filter function that filters the rows shown in the first two screenshots above and only returns the products that exceed the threshold. The formula is: FILTER ...

Prior to the new Dynamic Array functionality, you had to build array formulae if you wanted to work with ranges in Excel. Liam Bastick explains how they both compare.

Excel is full of useful features and functions that help users analyze and manipulate data. One of such features is the Excel Multi-Cell Array Formula. These formulas allow users to perform complex ...