As with array formulas, you can use array constants with most of the built-in functions that Excel provides. The following sections explain how to create each kind of constant and how to use these …

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

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

Returns a calculated array of a specified row and column size, by applying a LAMBDA function

If you are writing a dynamic array formula to act on a list of data, it can be useful to place it in an Excel table, then use structured references to refer to the data.

When you enter an array formula, you most often use a range of cells in your worksheet, but you don't have to. You can also use array constants, values you just enter in the formula bar inside braces: {}.

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.

Array constants can't contain other arrays, formulas, or functions. In other words, they can contain only text, numbers, or characters separated by commas or semicolons.

Here's what you need to do. Select the range of cells that contains your current array formula, plus the empty cells next to the new data. Press F2. Now you can edit the formula. Replace the old range of …

Dynamic arrays bring significant new calculation ability and functionality to Excel. Excel's upgraded formula language is almost identical to the old language, except that it uses the @ operator to …

Note An array can be thought of as a row or column of values, or a combination of rows and columns of values. In the examples above, the arrays for our UNIQUE formulas are range D2:D11, and D2:D17 …