ROW

ROW([reference])

Returns the row number of a cell reference.

reference

(Optional) The cell or range of cells for which you want the row number for.

REMARKS

* This function can return multiple values.
* This function can create a Dynamic Array Formula.
* The "reference" can be a cell reference or a named range.
* The "reference" cannot refer to multiple areas.
* If "reference" is left blank, then the reference of the cell containing the function is used.
* If "reference" is a range of cells, then the cell in the top left corner of the reference is used.
* If "reference" is a range of cells referring to more than one row, then a dynamic array formula is returned.
* You can use the ADDRESS function to return the cell reference given a row and column number.
* You can use the COLUMN function to return the column number of a cell reference.
* You can use the COLUMNS function to return the number of columns in a cell range or reference.
* You can use the ROWS function to return the number of rows in a cell range or reference.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=ROW() = 1	10
2	=ROW() = 2	20
3	=ROW(C1) = 1
4	=ROW(C4) = 4
5	=ROW(C1:C2) = { 1 ; 2 }
6	=ROW(1:1) = 1
7	=ROW(4:4) = 4
8	=ROW(INDIRECT("1:1") = { 1 }
9	=ROW(INDIRECT("1:5")) = { 1 ; 2 ; 3 ; 4 ; 5 }
10	=ROW(INDIRECT("3:5")) = { 3 ; 4 ; 5 }

1 - What row number is this formula in.
2 - What row number is this formula in.
3 - What row number is the cell range "C1".
4 - What row number is the cell range "C4"
5 - What row numbers are in the cell range "C1:C2". This cell range spans 2 rows.