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:
A |
B |
|
---|---|---|
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:
A |
B |
|
---|---|---|
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 |