Excel Multi Cell Array Formula Step by Step Tutorial

By Ted French, About.com Guide

Entering the Tutorial Data

To begin the tutorial it is necessary to enter our data into an Excel worksheet as seen in the image above.

Cell    Data
 D1  -  2
 D2  -  3
 D3  -  6

 E1  -  4
 E2  -  5
 E3  -  8

Previous

• Excel Array Formulas Overview
• Entering the Tutorial Data
• Creating the Base Formula
• Creating the Array Formula

Next