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.