Skip to content
ExcelExcel 2024+

CHOOSEROWS function in Excel

Returns the specified rows from an array

=CHOOSEROWS(array, row_num1, [row_num2], …)

CHOOSEROWS syntax and parameters

Three arguments, two required.

  • arrayarrayRequired
  • row_num1numberRequired
  • row_num2numberRepeating

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 Google Sheets

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 Excel gets this done.