COLUMN
Description
COLUMN returns the column number of the supplied reference.
Syntax
COLUMN ( reference )
|
Parameter |
Description |
|
reference |
A reference to a cell or range. Omitting the argument returns the number of the column in which COLUMN is placed. If reference is a range, the function returns the value of the first cell (left column, top line) in the selected range. |
Examples
This function returns 2:
COLUMN(B3)
The following function returns the number of the current column. For example, it returns 4 in the D2 cell:
COLUMN()
This function returns 5 if B3 is "5":
COLUMN(B3:Z10)
Also, see