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.

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 …

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.

Excel formulas that return a set of values, also known as an array, return these values to neighboring cells. This behavior is called spilling. Formulas that can return arrays of variable …

Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results.

To name an array constant, click Formula, then Define Name. Enter a name and the constant, then you can use the constant as an array formula.

See examples of how to enter the cell ranges (the table_array argument) in VLOOKUP and HLOOKUP functions.

This error occurs when Excel's calculation engine encounters an unspecified calculation error with an array. To resolve it, try rewriting your formula. If you have a nested formula, you can try …

Returns a calculated array of a specified row and column size, by applying a LAMBDA function. Syntax =MAKEARRAY (rows, cols, lambda (row, col)) The MAKEARRAY function syntax has …

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 …