Functions
CHOOSECOLS
Returns selected columns from an array
Try it
When to use it
When should I use CHOOSECOLS?
Use CHOOSECOLS to extract specific columns from an array by index, allowing you to reorder or subset columns without helper formulas.
Used in
Syntax
CHOOSECOLS(array, col_num1, ...)Examples
=CHOOSECOLS({1,2,3;4,5,6},1) // => 1
=CHOOSECOLS({1,2,3;4,5,6},3) // => 3
=CHOOSECOLS({1,2,3;4,5,6},1,3) // => 1