COL

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, 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.