Syntax #1:
ROW
Returns the number of the row containing the cell in which the function is evaluated.
Example:
ROW
in cell D16
returns the number 16
.
Syntax #2:
ROW(cell_reference|range)
If a cell reference is specified, ROW
returns the number of the row of that cell.
If a range is specified, the number of the first row in the range is returned.
Example:
ROW(A3:C12
)
returns the number 3
.