ROW
Syntax:
ROW ( [ reference ] )
Description: Finds the number of the row(s) corresponding to reference.
Arguments:
Name |
Type |
Description |
|---|---|---|
reference |
reference to a single cell or to a range of contiguous cells |
If omitted, the behavior is as if reference referred to the cell containing the formula. |
Return Type and Value: number – If reference refers to a single cell or to a single row of cells, the corresponding row is returned. If reference refers to a range of cells involving multiple rows, a vertical array of the corresponding rows as numbers is returned.
However, if the range of cells referred to by reference is not contiguous, #REF! is returned.
example: