Syntax #1:
COL
Returns the number of the column containing the cell in which the function is evaluated.
Example:
COL
in cell C5
returns the number 3
.
Syntax #2:
COL(cell_reference|range)
If a cell reference is specified, COL
returns the number of the column of that cell.
If a range is specified, the number of the first column in the range is returned.
Example:
COL(Z9)
returns the value 26
.