Table of Contents
The CHOOSECOLS function in Google Sheets allows users to select and display specific columns from a given range or array. This function is useful for organizing and analyzing data, as it allows for the customization of which columns are shown in a spreadsheet. By using the CHOOSECOLS function, users can easily manipulate and present their data in a concise and organized manner. This function is particularly helpful for large datasets, as it allows for a more streamlined and efficient analysis process. Overall, the CHOOSECOLS function in Google Sheets is a valuable tool for data management and presentation.
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
- CHOOSEROWS
Cite this article
stats writer (2024). How can I use the CHOOSECOLS function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-choosecols-function-in-google-sheets/
stats writer. "How can I use the CHOOSECOLS function in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-choosecols-function-in-google-sheets/.
stats writer. "How can I use the CHOOSECOLS function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-choosecols-function-in-google-sheets/.
stats writer (2024) 'How can I use the CHOOSECOLS function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-choosecols-function-in-google-sheets/.
[1] stats writer, "How can I use the CHOOSECOLS function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I use the CHOOSECOLS function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.