This function creates a new array from the selected columns in the existing range.
Learn ↓
How To Use CHOOSECOLS()
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: