What is the use of COLUMN function?
COLUMN Function in Excel returns the column number of the given reference
What is the syntax of COLUMN function?
COLUMN( reference)
reference : reference to find column number
COLUMN Function in Excel – Examples
Example 1: returns column number of the cell B14 (i.e; B=2)
Example 2: returns column number of the cell A14 (i.e; E=5)
Example 3: returns column number of the cell AB16 (i.e; AB=28)
Example 4: if you miss the argument it will return the column number of the cell where you have written the formula.
Reference:
Please refer the below article for more Lookup & Reference Excel functions.
Lookup & Reference Excel Formulas
Please refer the below article for more Excel Functions.
Excel Formulas | Home
A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.
LIMITED TIME OFFER
Advanced Project Planning Templates
Excel Templates
120+ Project Management Templates Pack
Excel | PowerPoint | Word
ULTIMATE RESOURCE MANAGEMENT TEMPLATE
Excel Template
50+ Essential Project Management Templates
Excel | PowerPoint | Word
Project Portfolio Management Templates
Excel | PowerPoint Templates
50+ Excel Project Management Templates
Excel Templates