Funzione di Google Sheets

CHOOSEROWS

Returns the specified rows from an array.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

CHOOSEROWS(array, row_num1, [row_num2], ...)

The CHOOSEROWS function extracts specific rows from a given array or range based on the row numbers provided. It is a dynamic array function that returns a new array containing only the selected rows in the order specified.

Argomenti

arrayobbligatorioThe array containing the rows to return.
row_num1obbligatorioThe index of the first row to return.
row_num2facoltativoAdditional row indices to return.

Esempi

=CHOOSEROWS(A1:C3, 1, 3)

Risultato: Returns the first and third rows of the range A1:C3.

This extracts the first and third rows from the specified 3-row range.

Domande frequenti

Can I use negative numbers for row indices?

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

Funzioni correlate

CHOOSECOLS FILTER INDEX