ROW

Excel Functions

Get the row number of a reference

Syntax

EXCEL

=ROW([reference])

Arguments

Parameter	Description
`reference`	[optional] A reference to a cell or range of cells.

Return Value

A number representing the row.

Details

The ROW function returns the row number for a cell or range. For example, =ROW(C3) returns 3, since C3 is the third row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula. ROW takes just one argument, called reference, which can be empty, a cell reference, or a range. When no reference is provided, ROW returns the row number of the cell which contains the formula. With a single cell reference, ROW returns the associated row number: When a reference is not provided, ROW returns the row number of the cell the formula resides in. For example, if the following formula is entered in cell D6, the result is 6: When ROW is given a range, it returns the row numbers for that range: In Excel 365, which supports dynamic array formulas,

Examples

With a single cell reference, ROW returns the associated row number:

EXCEL

=ROW(A1) // returns 1
=ROW(E3) // returns 3

Examples

When a reference is not provided, ROW returns the row number of the cell the formula resides in. For example, if the following formula is entered in c

EXCEL

=ROW() // returns 6 in D6

Examples

When ROW is given a range, it returns the row numbers for that range:

EXCEL

=ROW(E4:G6) // returns {4,5,6}

Examples

To get Excel 365 to return a single value, you can use the implicit intersection operator (@):

EXCEL

=@ROW(E4:G6) // returns 4

ROW

Syntax

Arguments

Return Value

Details

Examples

See Also