ROW
Returns the row number of a reference.
Lookup & ReferenceLookup & Matching Essentials
What it does
Returns the row number of a cell.
Syntax
ROW([reference])
Arguments
reference(reference) — Cell.
Examples
Get Row
Row of A5.
FORMULA
=ROW(A5)
RESULT
5
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 5 |