COLUMNS

Returns specific columns of a range.

Syntax

COLUMNS(range; columnIndex1; columnIndex2; …; columnIndexN)

• range - the range from which the columns should be extracted - Value type: range

• columnIndex1-N - the indicees of the columns which should be included in the return range - Value type: number

Remarks

• The order of the columns in the return range is the same as the order of the columnIndex parameters.

• If a column does not exist in range, a column with empty cells is included in the range.

• It is possible to use the same index multiple times, then the same column is included multiple times in the result range.

Examples

The left table is filled with the columns 1 and 3 of table1.

The left table is filled with several columns of table2 in a custom order. Including an empty column, by using 0 as index.