ROW

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 or range )

If a cell reference is specified, this function returns the number of the row of that cell.

If a range of cells is specified, the number of the first row in the range is returned.

Example:

ROW(A3:C12)

returns the number 3.