Formulas that can return arrays of variable size are called dynamic array formulas. Formulas that are currently returning arrays that are successfully spilling can be referred to as spilled array …

The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array functions, as well as …

In September, 2018 we introduced dynamic array formulas. Dynamic array formulas can automatically populate or "spill" into neighboring blank cells, and eliminate the need for legacy …

In September, 2018, we released dynamic array formulas for Excel for Microsoft 365. The differences between dynamic arrays and legacy Ctrl+Shift+Enter (CSE) formulas are …

In September, 2018 we announced that Dynamic Array support would be coming to Excel. This allows formulas to spill across multiple cells if the formula returns multi-cell ranges or arrays.

Learn about the SORTBY function, which sorts the contents of a range or array based on the values in a corresponding range or array. SORTBY is in a class of functions called dynamic …

The FILTER function will return an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press …

Learn about the SORT function, which sorts the contents of a range or array. SORT is in a class of functions called dynamic arrays.

Custom functions that refer to more than 10,000 cells cannot be calculated in Excel for the web, and will produce this #CALC! error instead. To fix, open the file in a desktop version of Excel.

There are now 14 new text and array functions in Excel 2024 and Excel 2024 for Mac that are designed to help you manipulate text and arrays in your worksheets. These functions make it …