This function creates a new array from the selected rows in the existing range.
Sample Usage
CHOOSEROWS(A2:B5, 1, 3, 1)
CHOOSEROWS(A2:B5, -1, -2, -3)
Syntax
CHOOSEROWS(array, row_num1, [row_num2])
array: The array that contains the rows to be returned.row_num1: The row number of the first row to be returned.row_num2…: [ OPTIONAL ] The row number(s) of additional row(s) to be returned.
Examples
Simple data extraction operation with CHOOSEROWS
Example data:
| 1 | Student | Grades |
|---|---|---|
| 2 | Harry | 95 |
| 3 | Jenny | 85 |
| 4 | Lily | 76 |
| 5 | Sunny | 60 |
Example: Input this formula in D1: =CHOOSEROWS(A1:B5, 1, 2, 4, 2)
Result:
| D | E | |
|---|---|---|
| 1 | Student | Grade |
| 2 | Harry | 95 |
| 3 | Lily | 76 |
| 4 | Harry | 95 |
Simple data extraction with CHOOSEROWS selecting rows ranked from the bottom
Example data:
| 1 | Student | Grade |
|---|---|---|
| 2 | Harry | 95 |
| 3 | Jenny | 85 |
| 4 | Lily | 76 |
| 5 | Sunny | 60 |
Example: Input this formula in D1: =CHOOSEROWS(A1:B5, 1, -1, -2, -3)
Result:
| D | E | |
|---|---|---|
| 1 | Student | Grade |
| 2 | Sunny | 60 |
| 3 | Lily | 76 |
| 4 | Jenny | 85 |