Syntax
COLUMN(Range)
Range (optional) – This is a single cell or range which you want the column number from. For ranges the column number of the upper left most cell will be returned. If no range is selected, the column in which the formula appears is returned.
Example
In this example we get the column number based on a single cell reference, no cell reference and a reference to a range of cells.