The COLUMN function returns the column number of ref according to the following:
ref |
returns |
cell |
column number |
range |
number of leftmost column in a range |
omitted |
current column number |
For example:
COLUMN(Z100) |
returns 26 |
COLUMN(D5..G10) |
returns 4 |
COLUMN(mycell) |
returns the column number of a named cell, mycell, or the leftmost column within mycell if it is a range. |
COLUMN( ) |
returns 5 if the function is entered in any cell in column E |
See also: