CHOOSEROWS
Returns the specified rows from an array
Syntax
CHOOSEROWS(array, row_num1, [row_num2], ...)
Parameters
- array: Required. The array containing the rows to be returned
- row_num1: Required. The first row to be returned
- row_num2: Optional. Additional rows to be returned
Example
=CHOOSEROWS(A1:D5, 1, 3, 5)