Función de Google Sheets

CHOOSECOLS

Returns the specified columns from an array.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

CHOOSECOLS(array, col_num1, [col_num2], ...)

The CHOOSECOLS function extracts one or more columns from a given array or range. You can specify columns by their index numbers, and the function will return them in the order provided.

Argumentos

arrayobligatorioThe array containing the columns to return.
col_num1obligatorioThe index of the first column to return.
col_num2opcionalAdditional column indices to return.

Ejemplos

=CHOOSECOLS(A1:C3, 1, 3)

Resultado: Returns columns 1 and 3 from the range A1:C3.

Extracts the first and third columns from the specified 3-column range.

Preguntas frecuentes

Can I use negative numbers for column indices?

Yes, negative numbers count from the end of the array (e.g., -1 is the last column).

Funciones relacionadas

CHOOSEROWS FILTER HSTACK VSTACK