This function returns the column number of a reference.

Syntax

COLUMN(reference)

Arguments

The argument is a cell or a single area.

Remarks

If the reference is omitted, the reference of the cell that the function is in is used.

Data Types

Accepts cell references. Returns numeric data.

Examples

COLUMN(A9) gives the result 1

COLUMN(A1:A5) gives the result 1

Version Available

This function is available in product version 3.0 or later.

See Also

ROWS | INDEX | Lookup Functions