Array

An array is range or group of related data values. In a spreadsheet program such as Excel the values in an array are normally stored in adjacent cells.

Uses for Arrays

Arrays can be used in both formulas (array formulas ) and as arguments for functions such as the array forms of the LOOKUP and INDEX functions.

Types of Arrays

There are two types of array in Excel:

• One - dimensional array - where the data is located in single column (one-dimensional vertical array) or row (one-dimensional horizontal array).


• Two - dimensional array - where the data is located in multiple columns or rows.