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

Hey! Join Our Community

Get Quick Responses & Experts' Answers in Minutes!
Get Notified - When Answered Your Question!