How to Use ROW Function

The ROW function is to return the row number of a reference.

Formula:

= ROW([reference])

Explanation:

The reference is optional. The row number of the cell or range of cells you are looking for.

  • When reference is omitted, it returns the row number of the current cell;
  • When reference is a range of data, it returns to the first row of data range.

=ROW() returns 2 which is the row number of D2.

=ROW(A3) returns 3 which is the row number of A3.

Download: ROW Function

Leave a Reply