Returns the column number of a reference.
Syntax
COLUMN([reference])Argumente
referenceoptional
The cell or range of cells for which you want the column number.
The COLUMN function returns the column index number for a given cell reference. If the reference argument is omitted, the function returns the number of the column where the formula is currently located.
=COLUMN(C1)→3Returns 3 because column C is the third column in the worksheet.
=COLUMN()→1Returns 1 if the formula is entered in cell A1.
Select a cell
Click on the cell where you want to display the column number.
Enter the formula
Type =COLUMN() and press Enter to get the current column, or =COLUMN(reference) to get the column of a specific cell.
The function will return the column number of the first column in the range.