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 …

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

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 …

Wenn Sie mit einer Matrixformel mehrere Ergebnisse berechnen möchten, geben Sie die Matrix (das Array) in einen Zellbereich ein, der dieselbe Anzahl von Zeilen und Spalten, die Sie in …

The implicit intersection operator was introduced as part of substantial upgrade to Excel's formula language to support dynamic arrays. Dynamic arrays bring significant new calculation ability …

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 can be thought of as a row of values, a column of values, or a combination of rows and columns of values. In the example above, the source array for our SORT formula is range …

Select the cell or range of cells that contains the formula. If the formula is an array formula, you must first select all cells in the range of cells that contains the array formula:

An array formula, in short, is a formula that gets applied to more than one cell. Because you selected more than one cell in step 1 (you did, didn't you?), the formula will get applied to …