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
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.