This function returns the column number of a reference.
COLUMN(reference)
The argument is a cell or a single area.
If the reference is omitted, the reference of the cell that the function is in is used.
Accepts cell references. Returns numeric data.
COLUMN(A9) gives the result 1
COLUMN(A1:A5) gives the result 1