COLUMN

Returns the column number of a cell.

 

Sample Usage

COLUMN(C5)
COLUMN()

Syntax

COLUMN([cell_reference])

  • cell_reference  - [OPTIONAL] The reference of the cell whose column number is to be returned. 

  

Examples

COLUMN(C5) returns the column number of cell C5
COLUMN() returns the column number of the cell in which the COLUMN function appears.

 

Notes

  • If the argument passed is a range of cells, the COLUMN function returns the column number of only the first column in the range.