Syntax
COLUMN([reference])
| Parameter | Description |
|---|---|
| [reference] | (Optional.) Parameter of the COLUMN function. |
Examples
Get column number
Formula
=COLUMN(D1)
Returns 4 — column D is the 4th column.
Dynamic header numbering
Formula
=COLUMN()-COLUMN($A$1)+1
Returns 1 in column A, 2 in column B, etc. Creates a relative column counter regardless of where your data starts.
Select nth column dynamically
Formula
=INDEX(A1:E1, COLUMN()-2)
Pulls values from a header row based on the formula's column position. Useful for building dynamic report layouts.
Common Errors
#VALUE!
Occurs only when passed an invalid reference. COLUMN with no argument or a valid cell reference never errors.
Tips
No argument = current column
=COLUMN() returns the column number of the cell containing the formula. In cell E3, it returns 5.
Column letter from number
To get the column letter: =SUBSTITUTE(ADDRESS(1, COLUMN(), 4), "1", ""). This converts column number 5 to "E".
Works like ROW but horizontal
ROW gives vertical position, COLUMN gives horizontal position. Both are essential building blocks for position-aware formulas.
Try COLUMN in Viztab
Import your data and use COLUMN with 370+ other formulas. No signup required.
Open Viztab