Excel COLUMN function

The ‘COLUMN’ function in Excel will return the column number of a specified cell. Column A is returned as column 1, column B is column 2, and so on.

Note: if you wish to know the number of columns within a specified cell range, you will need to use the COLUMNS function instead.

In addition to the COLUMN function, you could also use the CELL function to return the column number for a specified cell. For example;  =CELL(“col”,A1) would return the column number of cell A1.

Syntax

=COLUMN([reference])

Arguments

reference – input cell (i.e. the cell which you want to know the column number of)

Function category

Information

Returns

The COLUMN function will return the column number of a singular specified cell.

Download Excel File

 Example of COLUMN formula

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.