COLUMN

Returns a column of a range.

Syntax

COLUMN(range; columnIndex)

• range - a range of values - Value type: range

• columnIndex - the index of the column to return - Value type: number (optional, default value: 1)

Remarks

• If columnIndex is greater than the number of columns in range or smaller than 1, an empty column with the same amount of rows as range is returned.

• columnIndex can contain the text “last”. In this case, the last column of range is returned.

• The function COLUMN can be used to ensure that a parameter or operand is always handled as a column during an operation.

Example

The left widget is filled with the second column of table2, by calling the COLUMN function with 2 as second parameter.