Excel ROW Function

The Excel ROW function returns the row number for a reference. For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula.

=ROW(A3) // returns 3
=ROW(D5) // returns 5
=ROW(F10:J15) // returns 10