COLUMN

See also A-Z Spreadsheet Function List

Description Returns the column number of the supplied reference.

Syntax COLUMN(reference)

reference is a reference to a cell or range. Omitting the argument returns the number of the column in which COLUMN is placed.

See Also COLUMNS and ROW functions

Examples COLUMN(B3) returns 2

         COLUMN() returns 4 if the function is entered in cell D2.