The COLUMN function returns the column number of the column containing a specified cell.
COLUMN(cell)
cell: An optional cell reference to a single table cell. The referenced cell can contain any value, or be empty. If cell is omitted, as in =COLUMN(), the function returns the column number of the cell that contains the formula.
Examples |
|---|
=COLUMN(B7) returns 2, the absolute column number of column B. =COLUMN() returns the column number of the cell that contains the function. |