COLUMN Function

Written by kazamraza no comments
Classified in : Excel Formulas, Lookup Functions Tags : none
The COLUMN function returns the column number of the given cell reference. For example, the formula =COLUMN(D10) returns 4, because column D is the fourth column.

Syntax


	COLUMN([reference])

The COLUMN function syntax has the following argument:

  • reference Optional. The cell or range of cells for which you want to return the column number.
    • If the reference argument is omitted or refers to a range of cells, and if the COLUMN function is entered as a horizontal array formula, the COLUMN function returns the column numbers of reference as a horizontal array.
    • If the reference argument is a range of cells, and if the COLUMN function is not entered as a horizontal array formula, the COLUMN function returns the number of the leftmost column.
    • If the reference argument is omitted, it is assumed to be the reference of the cell in which the COLUMN function appears.
    • The reference argument cannot refer to multiple areas.

.