COLUMN
Description
Returns the column number of the reference that you specify.
Syntax
COLUMN([
reference
])
- reference: The reference to return the column number for. If not specified, COLUMN() returns the column number of the cell where you place the function.
Example
Formula | Result |
|---|---|
=COLUMN() where the current cell is B2. | 2 |
=COLUMN(J2:P2) | 10 |