1. Computing

Array

By

Excel Array Example

Excel Array Example

© Ted French
Definition:

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.

©2014 About.com. All rights reserved.