The ROW function is to return the row number of a reference.
Formula:
= ROW([reference])
Explanation:
The reference is optional. The row number of the cell or range of cells you are looking for.
- When reference is omitted, it returns the row number of the current cell;
- When reference is a range of data, it returns to the first row of data range.
=ROW() returns 2 which is the row number of D2.
=ROW(A3) returns 3 which is the row number of A3.