CHOOSEROWS Function in Google Sheets

Select specific rows from an array using the CHOOSEROWS function.

CHOOSEROWS Function

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

Syntax

CHOOSEROWS(array, row_num1, [row_num2])
  • array: The range or array from which to select rows.
  • row_num1: The number of the first row to select.
  • row_num2: Additional rows to select (optional).

Examples

  1. Basic Example

Select rows 1 and 3 from range A1:D10:

=CHOOSEROWS(A1:D10, 1, 3)

Notes

  • You can select multiple rows by specifying additional row numbers.
  • CHOOSECOLS: Select specific columns from an array.