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 …

To calculate multiple results by using an array formula, enter the array into a range of cells that has the exact same number of rows and columns that you’ll use in the array arguments.

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: {}.

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 …

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

When opening a workbook that contains dynamic array formulas in an older version of Excel, there are some compatibility considerations. Note: Dynamic array formula support was released to Microsoft …

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. This is because structured references …

數位公式是一種公式，可對陣列中的一或多個項目執行多項計算。 您可以將陣列視為值的列或欄，或是值的列與欄的組合。 數位公式可以傳回多個結果或單一結果。 從 Microsoft 365 的 2018 年 9 月更新開 …

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 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 …