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.