Arrays

A set of values or cell references entered in a single cell or as a spreadsheet function parameter, which may be used to represent any arbitrary set of data, a matrix, or a complex number.

Array constants should be entered in the form

{1,2,3;4,5,6}

with commas separating each element in a row of the array and semi-colons separating each row.

Many spreadsheet functions return array results, which can be passed to further functions. Cells containing an array-returning function just display the first (or top-left) element of that result. Individual elements (or sub-arrays) may be obtained from such results using the INDEX function.