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.
1. Excel Multi Cell Array Formula Step by Step Tutorial
Excel Multi Cell Array Formula
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.
2. Excel Single Cell Array Formula Step by Step Tutorial
Excel Single Cell Array 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.
3. Excel MAX IF Array Formula Tutorial
Excel MAX IF Array Formula Tutorial
4. Excel MIN IF Array Formula Tutorial
Excel MIN IF Array Formula Tutorial
5. Lookup Formula with Multiple Criteria in Excel
Excel Array Formula Tutorial
6. Excel TRANSPOSE Function
Excel TRANSPOSE Array Formula
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.
