How To Use CHOOSECOLS()

Description

This function creates a new array from the selected columns in the existing range.

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: