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

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
16610750507416099178
true
Search Help Center
true
true
true
true
true
35
false
false