## COLUMN Function

Written by kazamraza
no comments

Classified in : Excel Formulas, Lookup Functions

## 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.