Formula Functions / Functions A to C / CHOOSECOLS
CHOOSECOLS

The function returns the specified columns from an array.

Syntax

=CHOOSECOLS(array,col_num1,[col_num2],…)

Arguments

The function provides the following arguments:

Argument

Description

array

Refers to the array containing the columns to be returned.

col_num1

Refers to the first column to be returned. Required.

[col_num2]

[Optional] Refers to the additional columns to be returned.

Remarks

The function returns a #VALUE error if the absolute value of any of the col_num arguments is zero or exceeds the number of columns in the array.

Data Types

The function returns an array. The type of each value in the array depends on the parameter.

Examples

Version Available

This function is available in product version 16.0 or later.

Note: The CHOOSECOLS function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.