ROW Function in Excel

Home/Excel Formulas/ROW Function in Excel

What is the use of ROW function?

ROW Function in Excel returns the row 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 ROW function?

ROW Function in Excel- Syntax

ROW( reference)

reference : reference to find the row number

ROW Function in Excel – Examples

ROW Function in Excel- Example 1

Example 1: returns row number of A14 (=14)
Example 2: returns row number of A15 (=15)
Example 3: returns row number of A126 (=126)
Example 4: returns row number of A17 (=17)
Example 5: if you miss the argument it will return the row 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 17th, 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


vlookup trimhow to get developer tab in excel 2013how to run a macro in excel 2007workbook methodsvba save excel filetranspose vbaexcel vlookup rangehow to delete a row in excelvba practice projectsinsert row in excel shortcutexcel vba hide worksheetvlookup formula in excelhlookup explainedhow to title columns in excelvalue excel vbaexcel for begginershdr yes imex 1technical interview questions and answers for freshers pdfinterview questions and answers for programmerexcel vba delete blank rowsunlock an excel filepassword vba excelconsolidate excel sheets into oneduplicate rows excelexcel 2010 chart wizardmerge cell dataexcel unhidehow to use the pivot table in excel 2007excel coding basicsvba do until loop exampleexcel macro librarymeeting minute templateexcel button in cellhow to unlock macro password in excellearn to write macros in excelunprotect a workbookhow to use visual basic in excel 2007ms word vba tutorialpaste special excel 2007macros vbamerge cells in excel 2013microsoft office excel 2007 templatesaverageif excel 2013basic sql interview questions and answersusing hyperlinks in excelshort key to insert row in exceldml queries in sqlexcel vba print formexcel vba hide columnsdml and ddl queriesaccess vba case statementvba waitvba message box multiple linesdynamic excel chartsmacro recorder excelexcel vba recordsetms access vba recordsetvb6 combo boxvba unprotectoffset function in excel 2010macro open excel fileexcel macro graphaccess vba caseexcel schedule plannerinterview excel test samplehow to remove blank row in excelvba coding basicsdebug.print vbavba save as dialogopen excel file from access vbaconsolidate excel worksheetsddl sql commandsfor each vba excelvba left stringexcel vba hide columnsexcel advanced filter criteriafinancial dashboard examples in excel