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

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

Related functions

CHOOSEROWS

Need more help?

Try these next steps:

Post to the help community Get answers from community members

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