This function returns the number of a row from a reference.

Syntax

ROW(reference)

Arguments

The argument is a cell or a single area.

Remarks

If the reference is omitted, the reference of the cell that the function is in is used.

Data Types

Accepts a cell or a single area. Returns numeric data.

Examples

ROW(B2) gives the result 2

ROW(B1:B5) gives the result 1

Version Available

This function is available in product version 3.0 or later.

See Also

COLUMNS | INDEX | Lookup Functions