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( reference)

reference : reference to find the row number

ROW Function in Excel – Examples

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