ROW

Find ROW number of a reference in Excel
Returns the row number of a reference

Rational

Find ROW number of a reference.

Description

The Excel ROW function returns the row number of a reference cell.
For example, =ROW(E9:E10) returns 9 (9th from top to bottom of the spreadsheet). The function returns the row number of only the first cell of reference.

Syntax

=ROW([reference])

Parameters

reference [optional] – Reference cell to find the row number.

Return Value

An integer representing the row number of the reference.

Key Notes

  • The ROW function accepts empty, single cell or a range of cells as an argument.
  • Reference return the row number of the first cell in a range of cells.
  • Moreover, does not accept multiple areas. If the reference argument is blank or empty, then the function returns the row number of that formula cell.

Keep Reading Similar Functions:

Return address of a cell in Excel

ADDRESS

The ADDRESS function returns cell address from given row and column numbers of a worksheet. For example, if you pass ADDRESS(5,6) the function returns $F$5.

Read More »
Count of rows in a cell range in Excel

ROWS

The ROWS function returns the number of rows of a cell range or array formula, =ROWS(E10:F100) returns 91 (91 rows in the cell range i.e. 10 to 100).

Read More »
Count all columns of a cell range in Excel

COLUMNS

The COLUMNS function returns a count of all columns of a cell range or array formula, =COLUMNS(E10:F100) returns 2 (two columns E & F).

Read More »
Find number of areas in reference in Excel

AREAS

The AREAS function returns a number of areas or region. I.e., =AREAS((B2:C4,D8:F9)) returns 2 (number of areas), include extra sets of parentheses.

Read More »
Find column number for a reference in Excel

COLUMN

The COLUMN function returns the column number of a first reference cell. For example, =COLUMN(E10:F10) returns 5 (5th column, a sequence of E in alphabets).

Read More »