ROW
Returns the row number of a reference.
Syntax
ROW(reference)
Reference is the cell or range of cells for which you want the row number.
- If reference is omitted, it is assumed to be the reference of the cell in which the ROW function appears.
- If reference is a range of cells, and if ROW is entered as a vertical array, ROW returns the row numbers of reference as a vertical array.
- Reference cannot refer to multiple areas.
Examples
ROW(A3)
equals 3
When entered as an array formula in three vertical cells:
ROW(A3:B5)
equals {3;4;5}
If ROW is entered in C5, then:
ROW()
equals ROW(C5)
equals 5