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.