Array

An array is range or group of related data values. 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.

There are 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 function. A function containing an array is surrounded by curly braces. An example would be:

{ = TRANSPOSE ( A1 : A10 ) }