ROW(reference) returns the row number of a reference : ROW « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. ROW
Input the formula: =ROW(C10). Press Enter to get the result.
Input the formula: =ROW(C10)








19.13.ROW
19.13.1.ROW(reference) returns the row number of a referenceROW(reference) returns the row number of a reference
19.13.2.=ROW() returns the row number in which the formula appears=ROW() returns the row number in which the formula appears
19.13.3.=ROW(C4:D6) returns the first row in the reference=ROW(C4:D6) returns the first row in the reference
19.13.4.ROWS(array) returns the number of rows in a referenceROWS(array) returns the number of rows in a reference
19.13.5.=ROW(Scores) returns the first row of the Scores range=ROW(Scores) returns the first row of the Scores range