The ROW Function is used to get the row number of a cell reference in both Excel & Google Sheet. Like ROW(F4) will return 4 as the referred cell F4 is in the 4th row of the Google sheet.
- reference – [optional] A reference to a cell or range of cells. If this argument is omitted, the ROW function then returns the row number of the cell in which the formula resides.
In the below example we have added a range of cells(B2:D5) as reference argument of ROW function, and it returned the row number as 2 of the top-most row(which is 2nd row here) in the specified range.
In below example we used ROW function in cell E3 without any argument. So it returned the row number of the current cell which is 3.