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


excel formulas with examples pdf in hindiddl dclexport vbaexcel vba data typeinteractive excel dashboardspivot table advancevba variantvlookup explanationexcel macro to compare two columnsexcel vba pastespecialexcel vba open file and copy datadelete a row vbaexcel tickoffset excel formulausing the lookup function in excelexcel option button grouproot cause analysis excel templatecombine excel worksheets into one worksheetvba messageboxformula vlookup excelexcel timelines templatevba query tableexcel power pivot tutorialtasks template excelexcel advancedfilterhow to protect sheet in excelresource capacity planning template excelhow to build an excel macrovba case statementsvba celltutorial macros excelexcel graph macrocombobox templatemsgbox function in vbscriptexcel vba msgboxclear listboxexcel vba worksheet copyvba macros for beginnershow to loop in vbavlookup 2 criteriamicrosoft excel project schedule templatedata validation excel 2010definition of excel formulashow to use pivot table excel 2010macro buttonsfileexists vbaexcel vba unprotect worksheetproject management excel dashboard templatesuseful vba codes for excelexcel formula countifexcel vba msgbox inputexcel vba select columnconditional formatting in excel 2007 using if statementexcel shortcutmerge multiple worksheetscase sensitive vlookuphow to use the average function in excel 2013example macro exceldbms interview questions and answers pdf free downloadadvanced excel tutorial pdf 2010insert hyperlink excelpaste special skip blankssql interview question pdfexcel vba input boxlen function in vbadisplay duplicates in excelmessagebox functionvba change cell colorexcel iserrexcel macro clear cellsshortcut key to delete sheet in excelexcel spreadsheet passwordrgb excelunprotect excel sheet onlineword dashboard templatevlookup with condition