COLUMN function

Category: Lookup and reference functions

What does this function do?

Returns the column number of a reference.

Syntax:

COLUMN([reference])

• reference (opcional): The cell or range of cells for which you want to return the column number. If the reference argument is omitted, it is assumed to be the reference of the cell in which the COLUMN function appears.

Examples:

=COLUMN(B2)=2

=COLUMN(C7)=3

In cell A2, =COLUMN()=1