Navigation:  Formula Reference > Spreadsheet Formula Functions >

COLUMN

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

INDEX

ROWS