The ROW function returns the row number for a given cell or range reference.
This function can be useful for automatically numbering data, creating dynamic formulas that depend on the position in the table, and organizing conditional formatting that responds to the evenness or oddness of rows.
Syntax
ROW([reference])
Argument |
Description |
Permitted values |
|---|---|---|
[reference] |
(optional) Returns the row number for a given cell or range reference. By default, it takes the value of the cell in which the formula is located |
Cell or range address |
Examples of use
Determining the row number for a specific cell
To find the row number for cell A5:
=ROW(A5)
Result: 5.
Determining the row number for a range
If you specify a range, for example, B2:B10, the function will return the number of the first row in that range:
=ROW(B2:B10)
Result: 2.
Use without argument
If the function is in cell D3:
=ROW()
Result: 3.
Notes
–When specifying a range of cells, the function returns the number of the first row in the range.
–If the argument is not specified, the function returns the row number where the formula is located.
–Numbering does not depend on filtering or hiding rows.