Functions
CHOOSEROWS
Returns selected rows from an array
Try it
When to use it
When should I use CHOOSEROWS?
Use CHOOSEROWS to extract specific rows from an array by index, allowing you to reorder or subset rows without helper formulas.
Used in
Syntax
CHOOSEROWS(array, row_num1, ...)Examples
=CHOOSEROWS({1,2;3,4;5,6},1) // => 1
=CHOOSEROWS({1,2;3,4;5,6},3) // => 5
=CHOOSEROWS({1,2;3,4;5,6},1,3) // => 1