Syntax
=CHOOSECOLS(array, col_num1, [col_num2], ...)Arguments
| Argument | Required | Description |
|---|---|---|
array | Required | The range or array |
col_num1 | Required | A column number |
col_num2 | Optional | More column numbers |
How to use CHOOSECOLS
When CHOOSECOLS returns more than one value, the result spills into the cells below and to the right. Keep those cells empty, or you get #SPILL!.
CHOOSECOLS takes 2 required arguments and 1 optional argument, and accepts more values in the same pattern. Type =CHOOSECOLS( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=CHOOSECOLS({1,2,3;4,5,6}, 1, 3)Result Spilled result
| A | B | |
|---|---|---|
| 1 | 1 | 3 |
| 2 | 4 | 6 |
=CHOOSECOLS({1,2,3}, -1)Result =CHOOSECOLS({1,2}, 0)Result Related array functions
- ARRAY_CONSTRAINReturns the top left part of an array with at most the given number of rows and columns.
- ARRAYFORMULAReturns the result of a formula that works on whole ranges, so it can spill.
- BYCOLApplies a LAMBDA to each column of an array and returns one result per column.
- BYROWApplies a LAMBDA to each row of an array and returns one result per row.
- CHOOSEROWSReturns the given rows of an array (negative numbers count from the end).
- DROPRemoves a number of rows or columns from the start (positive) or end (negative) of an array.
- EXPANDExpands an array to the given number of rows and columns, filling new cells with a pad value.
- FILTERReturns the rows (or columns) of a range or array that meet a condition.
- FLATTENPuts the values of one or more ranges into a single column, reading row by row.