ROW function

Description

This ROW function return the row number for a reference. For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula.

​

Objective

Obtain the row number of a reference.

​

Syntax

=ROW([reference])

​

Arguements

reference - [optional] Reference to a cells or range of cells.

​

​