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.

An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas.

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.

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 …

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 …

Excel has limited support for dynamic arrays between workbooks, and this scenario is only supported when both workbooks are open. If you close the source workbook, any linked …

Bagian artikel ini didasarkan pada rangkaian kolom Excel Power User yang ditulis oleh Colin Wilcox, dan diadaptasi dari bab 14 dan 15 Excel 2002 Formulas, buku yang ditulis oleh John …

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.

O Excel fornece dois tipos de fórmulas de matriz: as fórmulas de matriz que executam vários cálculos para gerar um único resultado e as fórmulas da matriz que calculam vários resultados.