Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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:

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 »
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 »
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 »
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 »
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 »