1. Technology
Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:


was emailed to:

Thanks for sharing About.com with others!

You can opt-out at any time. Please refer to our privacy policy for contact information.



Excel Array Example

Excel Array Example

© Ted French

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.