COLUMN
Returns the column number of given cell reference or cell range. For ranges the top-left cell is used as pivot cell.
Syntax
=COLUMN([Cell or Range])
Arguments
| Name | Type | Description |
|---|---|---|
| Cell or Range (optional) | Range | Cell or cell range to get the column number for. If not given current cell is used. |
Return
| Type | Description |
|---|---|
| Number | The column number. |
Examples
| Formula | Result | Comment |
|---|---|---|
| Column B corresponds to number 2 |