An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as a row or column of values, or a combination of rows and columns of …

Create an array formula that calculates a single result This type of array formula can simplify a worksheet model by replacing several different formulas with a single array formula. Click the cell in …

This behavior is called spilling. 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 …

Use array constants in array formulas or by themselves to save time, and when you need values that aren't in your workbook.

To expand an array formula, select the current formula, the new data, the blank cells next to the new data, edit the formula, and press Ctrl+Shift+Enter.

Table formula Spilled array formulas aren't supported in Excel tables. Try moving your formula out of the table, or converting the table to a range (select Table Design > Tools > Convert to range).

The dynamic array formula technically only exists in cell D1, whereas with a legacy CSE formula, the formula would need to be entered in the entire range. Will automatically resize as data is added or …

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 Ctrl+Shift+Enter …

To change or edit an array formula, you need to follow some rules, especially if you have multi-cell formulas. This article spells out the rules.

The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows. Use TRANSPOSE to …