Returns the row number of a specified cell.
Sample Usage
ROW(A9)
Syntax
ROW([cell_reference])
-
cell_reference
- [ OPTIONAL - The cell in which the formula is entered by default ] - The cell whose row number will be returned.- if
cell_reference
is a range more than one cell wide and the formula is not used as an array formula, only the numeric value of the first row incell_reference
is returned.
- if
See Also
ROWS: Returns the number of rows in a specified array or range.
COLUMNS: Returns the number of columns in a specified array or range.
COLUMN: Returns the column number of a specified cell, with A=1
.
Examples
Returns the row number of a cell reference.