CHOOSECOLS Function in Google Sheets

Select specific columns from an array using the CHOOSECOLS function.

CHOOSECOLS Function

The CHOOSECOLS function in Google Sheets allows you to select specific columns from an array or range.

Syntax

CHOOSECOLS(array, col_num1, [col_num2])
  • array: The range or array from which to select columns.
  • col_num1: The number of the first column to select.
  • col_num2: Additional columns to select (optional).

Examples

  1. Basic Example

Select columns 1 and 3 from range A1:D10:

=CHOOSECOLS(A1:D10, 1, 3)

Notes

  • You can select multiple columns by specifying additional column numbers.