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.

Dynamic array resizes may trigger additional calculation passes to ensure the spreadsheet is fully calculated. If the size of the array continues to change during these additional passes and does not ...

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 ...

But what if there was a way to make your Excel formulas not just smarter, but dynamic? Dynamic arrays in Excel have transformed data management, making formulas more efficient and adaptable.

Microsoftが複数の値を返す「Dynamic arrays」をサポートした「Excel for Mac/iOS」をInsiderユーザー向けに公開しています。詳細は以下から。

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time.

a DA Excel dynamic array formula that is either spilling or blocked (#SPILL!) will be converted to a fixed CSE formula in earlier versions of Excel a formula entered in DA Excel as a multi-cell CSE ...

When your custom function returns an array of results, it's known as a dynamic array formula. For more information on dynamic array formulas in Excel, see Dynamic arrays and spilled array behavior.