An array formula can perform multiple calculations on one or more cells of data in Excel. The usefulness of functions such as VLOOKUP can be extended by using them in an array formula. These tutorials include step by step examples of how to use an array formula in Excel.
A multiple cell or multi cell array formula is an array formula that is located in more than one cell in a worksheet. The same calculations are carried out in multiple cells using different data for each formula.
Single cell array formulas normally first carry out a multi cell array calculation - such as multiplication - and then use a function such as or AVERAGE or SUM to combine the output of the array into a single result.
The TRANSPOSE function is used to copy data located in a row into a column or copy data located in a column into a row. This function is one of the few in Excel that must always be used as an array formula.