In this lesson we will learn how the COLUMN function works in Excel. The COLUMN Function is used to get the column number of a cell reference. Like COLUMN(F4) will return 6 as the referred cell F4 is in the 6th column of the Excel Spreadsheet.
- reference – [optional] A reference to a cell or range of cells. If this argument is omitted, the COLUMN function then returns the column number of the cell in which the formula resides.
Let’s understand with a simple example. In the below Excel Spreadsheet we have added a range of cells(B2:D5) as reference argument of COLUMN function in cell E1.
It returned the column number as 2 which is column B in the specified range.
In below example we used COLUMN function in cell E3 without any argument. So it returned the column number of the current cell which is 5(column C is the 5th column in the Excel Spreadsheet).