Using the Excel COLUMN Function
SummaryThe Excel COLUMN function is used to return the column number of a reference cell. For example, COLUMN (B4) would return 2 since column B is the second column in the worksheet. If a reference isn't provided, the function will return the column in which the function was entered.
The ROW function can be used if you need to find the row number of a reference cell.
Optional. Reference can be blank, in which case the function returns the column in which it was entered, or you can specify a cell or range of cells.
Usage NotesCOLUMN returns the column number of a reference cell.
Entering a Range of Cells
If the reference argument is a range of cells and COLUMN is not entered as a horizontal array formula, the function will return the column number of the leftmost column.