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:

 
 

A

B

1

Student

Grades

2

Harry

95

3

Jenny

85

4

Lily

76

5

Sunny

60

 

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

Result:

 
 

D

E

1

Student

Grade

2

Harry

95

3

Lily

76

4

Harry

95

Make a Copy

 

Simple data extraction with CHOOSEROWS selecting rows ranked from the bottom

 

Example data:

 
 

A

B

1

Student

Grade

2

Harry

95

3

Jenny

85

4

Lily

76

5

Sunny

60

 

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

Result:

 

D

E

1

Student

Grade

2

Sunny

60

3

Lily

76

4

Jenny

85

Make a Copy

Related functions

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
true
false
true
true
35
false
false