|
<< Click to Display Table of Contents >> ROW (row number of cells) |
Syntax:
ROW([Reference])
Description:
This returns the row number(s) of a cell or cell range:
If Reference is a single cell, the row number of this cell is returned.
If Reference is a range of cells, their row numbers are returned as a vertical array. Note: In this case, the formula has to be entered as an array formula (see Working with arrays).
If Reference is omitted, the row number of the cell that contains this function is returned.
Example:
ROW(D2) returns 2
ROW(D2:F4) returns {2;3;4}
ROW() returns 5 when you use this function in cell A5
See also: