What COLUMN does
COLUMN returns a column number. It is useful in formulas that need to identify where data sits horizontally, especially when the workbook structure may shift later.
Practical examples
Return the column number of a specific cell
=COLUMN(D10)
This returns 4 because column D is the fourth column.
Build a running column sequence
=COLUMN(C2)-COLUMN($C$2)+1
This turns worksheet column positions into a sequence that starts at 1.
Common mistakes and notes
Omitting the reference uses the current cell
If you enter COLUMN() by itself, Excel returns the column number of the cell that holds the formula.
Ranges return the leftmost column unless spilled as an array
A multi-column reference in a normal formula returns the first column number rather than every column number.
COLUMN is often used inside larger formulas
Like ROW, COLUMN is commonly a building block for dynamic references, offsets, and reusable array logic.