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 an array.
* 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 a vertical array and the function is entered as a vertical array formula using (Ctrl + Shift + Enter) then an array of row numbers is returned.
* 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.office.com

 AB
1=ROW() = 110
2=ROW() = 220
3=ROW(C1) = 1 
4=ROW(C1:C2) = 1 
5{=ROW(C1:C2)} = 1 
6{=ROW(C1:C2)} = 2 
7=ROW(1:1) = 1 
8=ROW(4:4) = 4 
9{=ROW(INDIRECT("1:1")) } = {1} 
10{=ROW(INDIRECT("1:5")) } = {1,2,3,4,5} 
11{=ROW(INDIRECT("3:5")) } = {3,4,5} 

Rows 5 & 6 have been entered as an array formula.
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top