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.