COLUMN
Returns the column number of a reference.
Lookup & ReferenceLookup & Matching Essentials
What it does
Returns the column number of a cell reference.
Syntax
COLUMN([reference])
Arguments
reference(reference) — Optional. The cell or range.
Examples
Column Number
Get column number of C1.
FORMULA
=COLUMN(C1)
RESULT
3
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 3 |