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.


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

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