Skip to main content

COLUMN

Definition of COLUMN

Returns the column number of a specified cell, with `A=1`.

Sample Usage

COLUMN(A9)

Syntax

COLUMN([cell_reference])

  • cell_reference - [ OPTIONAL - By default, the cell containing the formula ] - The cell whose column number will be returned. Column A corresponds to 1.

    • if cell_reference is a range more than one cell wide and the formula is not used as an array formula, the position of the first column in cell_reference is returned.

See Also

ROWS: Returns the number of rows in a specified array or range.

ROW: Returns the row number of a specified cell.

COLUMNS: Returns the number of columns in a specified array or range.

In order to use the COLUMN formula, start with your edited Excellentable:

Then type in the COLUMN Formula in the area you would like to display the outcome:

By clicking on the cell you would like to calculate the COLUMN formula for, Excellentable will generate the outcome:

 

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.