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


colorindex excel 2013concatenate excel formulaexcel vba sumifvbscript to copy files from one folder to anotherexcell concatenateexcel 2003 pivot tablesconcatenate formulascountifs functioninsert rows vbasimple macros in excelbasic excel macrosexcel vba instr functionvlookup using 2 criteriaunhide all rows in excelsave a workbook vbasumif tutorialline break in vbaproject schedule template xlsvba interior colorarray vbaexcel vba status bar progressautofit vbaexcel worksheet rangemacro to unlock excel spreadsheetexcel combine multiple worksheetsvba user defined functioncreating pie charts in excel 2010how to use countifs in excelaccess vba message boxexcel activesheetexcel remove empty rowsmultiple case statement in teradatadelete blankshow to count repeats in excelexcel how to write a macroconditional if statement exceltotal no of rows and columns in excelexcel macro lookupvba object oriented programmingexcel sort macrosql interview questions and answers for freshers pdf downloadunlock excel sheet passwordvba format cellexcel ribbon menuvba to remove duplicateshow to remove all hyperlinks in excelcreate form vbahow to use name manager in excel 2010excel dynamic cell referencecopy a worksheet in excelexcel formula to hide rowsshortcut key for pivot table in excel 2007excel macro functionsexcel vlookup formulaexcel vba formathow to delete duplicates in excelvba excel find character in stringclose workbook vbaexcel isna vlookuphow to adjust column widthexcel formula operatorshow to put columns in excelddl in dbmscount rows excelexcel vb macrorept function excelexcel macro sheetshow to unprotect excel with passwordvlookup between sheetsc programming viva questions and answers pdfestimation templates