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 or range )
If a cell reference is specified, this function returns the number of the column of that cell.
If a range of cells is specified, the number of the first column in the range is returned.
Example:
COL(Z9)
returns the value 26
.