Excel like a finance pro.
← The libraryPractice · 3 questions →
Dynamic array function
CHOOSEROWS
Returns the chosen rows from an array.
OccasionalDifficulty 1400 · AdvancedUsage rank #111 of 520
When to use it
Returns the rows you name from an array, in that order. Negative numbers count from the bottom.
The shape of it
- Syntax
=CHOOSEROWS(array, row_num1, [row_num2], ...)
Worked examples
Pick rows
=CHOOSEROWS(A2:C6,1,3) → Widget row, Gizmo row
Rows 1 and 3.
Last row
=CHOOSEROWS(A2:C6,-1) → Widget Pro row
The last row.
First two rows
=CHOOSEROWS(A2:C6,SEQUENCE(2)) → first two rows
Rows 1 and 2.
Worth knowing
- Last row of a table: CHOOSEROWS(range,-1), cleaner than INDEX with ROWS.
- Reverse a list: CHOOSEROWS(range,SEQUENCE(ROWS(range),1,ROWS(range),-1)).
- Feed it MATCH results to pull specific records.
Where it goes wrong
- #VALUE! for a row number of 0 or out of range.
- Requires Microsoft 365.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.