COLUMN

Definition: COLUMN is a function that returns the column number of a cell reference.

Syntax: =COLUMN(reference)

Situation: This formula is suitable when you need to retrieve the column number of a cell for use in a calculation.

Example: If you have a cell reference A1, the column number can be found using the formula =COLUMN(A1), which returns 1.