CHOOSEROWS function

Category: Lookup and reference
Introduced: Excel 2024

Summary

Returns the specified rows from an array

Syntax

CHOOSEROWS(array,row_num1,[row_num2],…) The CHOOSEROWS function syntax has the following arguments:
• array The array containing the columns to be returned in the new array. Required.
• row_num1 The first row number to be returned. Required.
• [row_num2] Additional row numbers to be returned. Optional.

Example

=CHOOSEROWS(A2:B7,1,3,5,1)
=CHOOSEROWS(A2:B7,{1,3},5,1)
=CHOOSEROWS(A2:B7,-1,-2)

Microsoft Support Page

https://support.microsoft.com/en-us/office/chooserows-function-51ace882-9bab-4a44-9625-7274ef7507a3

Back to Functions