ROW function
ROW returns the row number of a cell reference.
ROW
If a reference is to a cell, the ROW function returns the row number of the cell.
Syntax
ROW(reference)
reference is a cell, an area, or the name of an area.
If you do not indicate a reference, the row number of the cell that contains the formula is found. The reference to the current cell is automatically set.
Example
=ROW(B3) returns 3 because the reference refers to the third row in the table.
{=ROW(D5:D8)} returns the single-column array (5,6,7,8) because the reference specified contains rows 5 through 8.
=ROW(D5:D8) returns 5.
{=ROW(A1:E1)} and =ROW(A1:E1) both return 1
=ROW() returns 3 if the formula was entered in row 3.