CHOOSEROWS function

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:

 

 

Example: Input this formula in D1: =CHOOSEROWS(A1:B5, 1, 2, 4, 2)

Result:

 

Make a Copy

 

Simple data extraction with CHOOSEROWS selecting rows ranked from the bottom

 

Example data:

   

Example: Input this formula in D1: =CHOOSEROWS(A1:B5, 1, -1, -2, -3)

Result:

Make a Copy

Related functions

• CHOOSECOLS