FUNCTION CATALOGUE / LOOKUP & REFERENCE
CHOOSEROWS Excel function
Returns selected rows from an array.
Correct sentence to use
Return rows [row numbers] from [array].
Modify this query in PlainFormula →Example formula
=CHOOSEROWS(A1:F20,1,3,6)
Returns specified rows.
Syntax
CHOOSEROWS(array, row_num1, [row_num2], …)
Argument signature: array, row_num1, [row_num2], …
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.