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 INDIRECT function to return the value of a given cell reference specified by a text string.
* 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

	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("A1:" & "C3")) = { 1 ; 2 ; 3 }
10	=ROW(INDIRECT("A9:B" & B1)) = { 9; 10 }

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.
6 - What row numbers are in the rows 1:1.
7 - What row numbers are in the rows 1:4. This returns 4 values.
8 - What row numbers are in the cell range "1:1".
9 - What row numbers are in the cell range "A1:C3".
10 - What row numbers are in the cell range "A9:B10".