# 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.

© 2024 Better Solutions Limited