Skip to main content

COLUMN function

The COLUMN function is one of the lookup and reference functions. It is used to return the column number of a cell.

Syntax​

COLUMN([reference])

The COLUMN function has the following argument:

ArgumentDescription
referenceA reference to a cell.

Notes​

reference is an optional argument. If it is omitted, the function will return the column number of a cell selected to display the COLUMN function result.

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the COLUMN function.

Examples​

The figure below displays the result returned by the COLUMN function.

COLUMN Function