• Share

Discuss in my forum

# Excel Array Formula Tutorials

## Carrying out Multiple Calculations with an Array Formulas

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
This tutorial combines the MAX and IF functions in an array formula in order to find the largest or maximum value for a range of data when a specific criterion is met.

### 4. Excel MIN IF Array Formula Tutorial

Excel MIN IF Array Formula Tutorial
This tutorial combines the MIN and IF functions in an array formula in order to find the smallest or minimum value for a range of data when a specific criterion is met.

### 5. Lookup Formula with Multiple Criteria in Excel

Excel Array Formula Tutorial
By using an array formula in Excel we can create a lookup formula that uses multiple criteria to find information in a database. The array formula used in this tutorial involves nesting the MATCH function inside the INDEX function.

### 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.

Ted French