ROW

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