Related Topics: | ||
Description: Based on a reference, returns the row number.
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.
Example:
If ROW is entered in A2, then:
ROW() = 2 [the row in which the formula appears]
ROW(C10) = 10 [the row of the reference]
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.