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.
उपयुक्त आहे का?
कॅरॅक्टर मर्यादा : 250
कमाल कॅरॅक्टर मर्यादा 250 आहे.
तुमच्या प्रतिक्रियेबद्दल धन्यवाद.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.