The COLUMN function in Excel returns the column number for a reference. In other words, Column Function too will return the column number of the cell which contains formula when reference is not provided.

➡ What is Column Function in Excel?

The function which will returns column number for a reference is called Excel COLUMN Function. It returns the number representing the column.

COLUMN Function uses reference to get column number. Reference can be a single cell address or a range of cells in Excel. Reference will default to the cell in which the COLUMN Function is present.

➡  What is the Syntax for Column Function?

The Syntax for COLUMN Function is-

=COLUMN ([reference])


Reference – It is a reference to a cell or range of cells.

➡ How to use the Column Function?

COLUMN Function is used in giving numbers to the columns of cells in excel sheet. Below example will help you to know how to use the Excel Column Function

➡ Example:

Here, we have taken three different ways of using this function in the formula. First, if we do not give any cell reference to the function, it will consider the same cell. Second, if we give reference of any cell, it will give the correct number for that column. Therefore, even if we enter range of cells as the reference it will give correct result.

Column Function in Excel

➡ Where can we use Column Function? 

  • Unlike Column Function, Index function too will help to sum the last n columns in a table of data.
  • In other words, Excel Column Function will also get a full set of relative column numbers in a range.
  • In addition to the COLUMN() functions, ROW() function will help you to dynamically increment a calculation
  • To convert a column letter into a regular number, you can use a formula based on the INDIRECT and COLUMN Functions

Recommended Blog:

➡ Top 3 Points to Remember:

Reference cannot include multiple references or addresses:

  • Similarly, even if reference is not provided, COLUMN Function returns the column number of the cell that contains the formula
  • If you give a text value as a reference to the COLUMN Function, you will get a #NAME? error
  • A number value entered as a reference will not be accepted in COLUMN Function

➡ Conclusion:

Here, we come to know about the COLUMN Function. The purpose, uses, formula to be used, where can we find this function are all explained above. Hope your concept regarding the COLUMN Function is clear and you can now carry out this function easily.

Leave a Reply

Related Tutorials

Connect to Data in Power Query
February 21, 2019
How to use Text to Column in Excel with 4 Difference Example
February 21, 2019
Things you should learn in Excel Course
February 13, 2019
How to use Clean Function in Excel
February 11, 2019
How to use the Excel Choose Function
February 11, 2019
How to use the Excel Code Function
February 11, 2019
How to use Ceiling Function in Excel
January 30, 2019
How to use Char Function in Excel
January 28, 2019
Text To Column in Excel | Split Cells
January 4, 2019
Pivot Tables (Complete Guidelines)
December 27, 2018
Power Bi Dax Deduplication Based On Column
December 17, 2018
Special Character Symbol List with Shortcodes in Excel
December 15, 2018
December 10, 2018
December 10, 2018
How to use ABS Function in Excel
December 10, 2018
How to use AND Function in Excel
December 10, 2018
Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas and Functions in PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018