This function returns the number of a row from a reference.
Syntax
ROW(reference)
Arguments
The argument is a cell or a single area.
Remarks
If the reference is omitted, the reference of the cell that the function is in is used.
Data Types
Accepts a cell or a single area. Returns numeric data.
Examples
ROW(B2) gives the result 2
ROW(B1:B5) gives the result 1
Version Available
This function is available in product version 3.0 or later.
See Also
COLUMNS | INDEX | Lookup Functions