The COLUMN function returns the column number of the top left cell of a cell reference. If the argument is not entered the column number of the cell the formula is entered in is returned, see cell B6 in picture above.
Excel Function Syntax
Optional. The cell reference for which you want to extract the column number from.
The COLUMN function allows you to also return an array of column numbers if you enter the formula as an array formula and use a cell range containing multiple columns.
You can not use multiple cell references in the COLUMN function.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Article with the 'COLUMN' Function
The following article has a formula that contains the COLUMN function.