Syntax
=COLUMN([reference])Arguments
| Argument | Required | Description |
|---|---|---|
reference | Optional | A cell or range (optional) |
How to use COLUMN
When COLUMN returns more than one value, the result spills into the cells below and to the right. Keep those cells empty, or you get #SPILL!.
COLUMN takes no required arguments and 1 optional argument. Type =COLUMN( 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.
=COLUMN(D10)Result =COLUMN(A1:C1)Result Spilled result
| A | B | C | |
|---|---|---|---|
| 1 | 1 | 2 | 3 |
Related lookup and reference functions
- ADDRESSBuilds a cell address as text from a row and column number.
- AREASReturns the number of areas (separate ranges) in a reference.
- CHOOSEReturns the value in a list at the given position.
- COLUMNSReturns the number of columns in a range or array.
- FORMULATEXTReturns the formula in a cell as text.
- GETPIVOTDATAReturns data from a pivot table. Refer to the pivot table cells directly instead.
- HLOOKUPLooks for a value in the first row of a table and returns the value in the same column from another row.
- INDEXReturns the value or reference at a given row and column of a range or array.
- INDIRECTReturns the reference written in a text value, such as "B3" or "Sheet2!A1:A10".