ROW function
Summary
Returns the row number of a reference
Syntax
ROW([reference])
The ROW function syntax has the following arguments:
• Reference Optional. 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.
• 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.
• Reference Optional. 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.
• 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.
Example
=ROW()
=ROW(C10)
=ROW(C10)