Using the Excel COLUMN Function
Summary
The 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.
Syntax
=COLUMN ([reference])Syntax Breakdown
ReferenceOptional. 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 Notes
COLUMN 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.
