ROW

The ROW function returns the row number of the row containing a specified cell or range of cells.

ROW(reference)

reference: An optional cell reference to a single table cell or a range of cells. The referenced cell(s) can contain any value, or be empty. If reference is omitted, as in =ROW(), the function returns the row number of the cell that contains the formula.

Examples

=ROW(B7) returns 7, the number of row 7.

=ROW() returns the absolute row number of the cell containing the function.

See alsoCOLUMNINDEX
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.