Skip to content
Google Sheets

CHOOSEROWS function in Google Sheets

Creates a new array from the selected rows in the existing range.

=CHOOSEROWS(array, row_num1, [row_num2])

CHOOSEROWS syntax and parameters

Three arguments, two required.

  • arrayarrayRequired

    The array that contains the rows to be returned.

  • row_num1numberRequired

    The row number of the first row to be returned.

  • row_num2numberRepeating

    [ OPTIONAL ] The row number(s) of additional row(s) to be returned.

CHOOSEROWS examples

Formulas you'll actually reuse.

  1. The first three rows of a ranked list — an instant top 3:

    =CHOOSEROWS(A2:D200, 1, 2, 3)

  2. The newest entry of an append-only log — negatives count from the bottom:

    =CHOOSEROWS(A2:D200, -1)

CHOOSEROWS in Excel

Same name — your formula ports as-is.

Try CHOOSEROWS in the playground

Edit the example — nothing to install.

Preloaded with the CHOOSEROWS formula from Example 1 — change anything and watch it respond.

Loading the editor…

CHOOSEROWS errors

What they mean — and the fixes.

  • #VALUE!

    A row number is 0 or beyond the array's height — indexes are 1-based, and negative ones count back from the last row.

Related functions

More ways Google Sheets gets this done.