CHOOSECOLS function

This function creates a new array from the selected columns in the existing range.

Sample Usage

CHOOSECOLS(A1:E5, 1, 3, 1)

CHOOSECOLS(A1:E5, -1, -2, -3)

Syntax

CHOOSECOLS(array, col_num1, [col_num2])

  • array: The array that contains the columns to be returned.
  • col_num1: The column number of the first column to be returned.
  • col_num2…: [ OPTIONAL ] The column number(s) of additional column(s) to be returned.

Examples

Simple data extraction operation with CHOOSECOLS

 

Example data:

 

A

B

C

D

E

1

Student

Math

History

Science

Gym

2

Harry

95

70

82

78

3

Jenny

85

91

100

80

4

Lily

76

88

80

95

5

Sunny

60

77

89

80

 

Example: Input this formula in G1: =CHOOSECOLS(A1:E5, 1, 3, 2)

Result:

 

G

H

I

1

Student

History

Math

2

Harry

70

95

3

Jenny

91

85

4

Lily

88

76

5

Sunny

77

60

Make a Copy

Simple data extraction with CHOOSECOLS selecting columns from the right side

 

Example data:

 

A

B

C

D

E

1

Student

Math

History

Science

Gym

2

Harry

95

70

82

78

3

Jenny

85

91

100

80

4

Lily

76

88

80

95

5

Sunny

60

77

89

80

 

Example: Input this formula in G1: =CHOOSECOLS(A1:E5, 1, -1, -2)

Result:

 

G

H

I

1

Student

Gym

Science

2

Harry

78

82

3

Jenny

80

100

4

Lily

95

80

5

Sunny

80

89

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