COLUMN function

Description

This COLUMN function return the column number for a reference. For example COLUMN(C5) return 3, since C is the third column in the spreadsheet. When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

​

Objective

Obtain the number of a reference.

​

Syntax

=COLUMN([reference])

​

Arguements

reference - [optional] Reference to a cell or range of cells.

​

​