The ROW function returns the row number of the row containing a specified cell.
ROW(cell)
cell: An optional cell reference to a single table cell. The referenced cell that can contain any value, or be empty. If cell is omitted, as in =ROW(), the function returns the row number of the cell that contains the formula.
Examples |
|---|
=ROW(B7) returns 7, the number of row 7. =ROW() returns the absolute row number of the cell containing the function. |