COLUMN(ref)

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:

Other lookup functions