COLUMN Function in Excel

Home/Excel Formulas/COLUMN Function in Excel

What is the use of COLUMN function?

COLUMN Function in Excel returns the column number of the given reference

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


What is the syntax of COLUMN function?

COLUMN Function in Excel- Syntax

COLUMN( reference)
reference : reference to find column number

COLUMN Function in Excel – Examples

COLUMN Function in Excel- Example 1

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

LIMITED TIME OFFER
By |April 20th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment


Related pages


vba loopingexcel remove empty linescount columns excelvba coding in excel for beginnershow to check for duplicates excelexcel vba application.runsample vba code for excelexcel convert table to rangehow to prepare dashboard in excelhow to find duplicate entries in excelvba code dimexcel formulas average ifexcel 2007 checkboxhow to use userform in excelexcel proposal templatehow to use iferror in excel 2010microsoft excel vba programming for dummies 2010sql beginnersvba recordpaste special skip blanksvba trim functionexcel range interior colorexcel 2003 find duplicatesexcel formula hideddl example sqlms access run query vbaexcel activeworkbook.saveashow to eliminate duplicates in excel 2010vba excel commentauto sorting in excelcountif in excel examplevisual basic commands excelfull form of vba in excelcopy paste macrowhat is a vlookup in excelexcel project management dashboardvba access export to exceltick box in excel 2007excel clear formattingdashboard using exceladvance filter in excelentirerow.deletedata validation in excel 2007 with exampleexcel vba current sheetinsert worksheet excelhow to title columns in excelhow to do pivot table in excelmultiple if statements in excelexcel vb macrovba string manipulationtask tracking template excelms excel advanced tutorialexcel unhide column avba code to open a filehow do i merge cells in excel 2010sas macros interview questionsexcel comparison operatorsvba access databasevlookup example between two sheetsisna excel formulaexcel macro break loopexcel macro to unhide all sheetshide excel sheet with passwordexcel vba range formulasas sql tutorialgoto function in vbacopy to clipboard vbaexcel vba function rangehow to delete unwanted rows in excelunhide excel 2010open xlsx with excel 2003sheet vbaunprotect xlsexcel vba formulavba declaration