This function creates a new array from the selected columns in the existing range.
Learn ↓
Description
How To Actually Use CHOOSECOLS() in Sheets
CHOOSECOLS(array, col_num1, [col_num2])
0Better Sheets Tutorials
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.
Learn more about the CHOOSECOLS() formula:
Better Sheets
Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.
Start 7 Day Free TrialGoogle Sheets Help
Google Sheets Courses
Google Sheet Templates and Tools
Google Sheet Add Ons