COL(C)

 

Description

This function returns the column index of the cell referenced by C, or the leftmost column if C is a range, or the column in which the formula appears if C is omitted.

 

Parameters

 

C

A cell or range (optional).

 

Examples

 

COL(A1) = 0

 

COL(F10:G19) = 5

 

COL() = 25

Where the expression is in cell Z20.