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.
There are two types of array in Excel:
- One - dimensional array - where the data is located in single column or row.
- Two - dimensional array - where the data is located in multiple columns or rows.
Uses for Arrays
An array can be used in an array formula.
There are also a number of functions in Excel, such as the TRANSPOSE and LEN functions, that require an argument to be entered as an array in order for them to give the correct results.
An array is included in a function by pressing the CTRL, SHIFT, and ENTER keys after typing in the formula or function. As a result the formula or function is surrounded by curly braces.
An example would be:
{ = TRANSPOSE ( A1 : A10 ) }
