ROW Function

Written by kazamraza no comments
Classified in : Excel Formulas, Lookup Functions Tags : none
Returns the row number of a reference.

Syntax


ROW([reference])

The ROW function syntax has the following arguments:

  • Reference Optional. The cell or range of cells for which you want the row number.
    • If reference is omitted, it is assumed to be the reference of the cell in which the ROW function appears.
    • If reference is a range of cells, and if ROW is entered as a vertical array, ROW returns the row numbers of reference as a vertical array.
    • Reference cannot refer to multiple areas.
◢ A B C D E
1 Formula Description Result    
2 =ROW() Row in which the formula appears 2    
3 =ROW(C10) Row of the reference 10    
4          

 

.