Formulas and Functions
CHOOSEROWS
The CHOOSEROWS function returns specific rows from an array.
CHOOSEROWS(array, row-index, row-index…)
array: The array containing the rows to be returned.
row-index: The row numbers to be returned.
row-index…: Optionally include additional rows to be returned.
Notes
A negative value for row-index takes from the end of the array.
You can use the spilled range operator “#” to reference an array created by a formula.
Examples |
|---|
=CHOOSEROWS(A1:E5, 1,4) returns rows 1 and 4. =CHOOSEROWS(A1:E5, 2,3) returns rows 2 and 3. =CHOOSEROWS(A1:E5, 1, -1) returns rows 1 and 5, the first row and last row from the array. |
See alsoCHOOSECOLS