What is COLUMN function in Excel?
The COLUMN function is one of the Lookup & reference functions of Excel.
It Returns the column number of a reference.
We can find this function in Lookup & reference category of the insert function Tab.
How to use COLUMN function in excel
- Click on an empty cell (like F5 ).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Lookup & reference category.
5. Select COLUMN function.
6. Then select ok.
7. In the function arguments Tab, you will see the COLUMN function.
8. Reference is the cell or range of contiguous cells for which you want the column number.
9. For example If you click on G4, see result= 7.
10. If you click on A4 , see result =1.
11. You will see the result in the formula result section.
Examples of COLUMN function in excel
COLUMN related functions
- COLUMNS function
- ROW function
- FILTER function
- INDEX function
