Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Lookup and Reference > ROW
 

ROW([reference])

 
 Returns the row number of the cell reference.

 referenceThe cell or range of cells for which you want the row number for.

 REMARKS
 
  		• This function can return an array.
     
  		• The "reference" cannot refer to multiple areas.
     
  		• If "reference" is left blank, then the reference of the cell containing the function is used.
     
  		• If "reference" is a range of cells, then the cell in the top left corner of the reference is used.
     
  		• If "reference" is a range of cells referring to a vertical array and the function is entered as a vertical array formula using (Ctrl + Shift + Enter) then an array of row numbers is returned.
     
  		• Rows 5 & 6 have been entered as an array formula.

     EXAMPLES
     
     AB
    1=ROW() = 110
    2=ROW() = 220
    3=ROW(C1) = 1 
    4=ROW(C1:C2) = 1 
    5{=ROW(C1:C2)} = 1 
    6{=ROW(C1:C2)} = 2 
    7=ROW(1:1) = 1 
    8=ROW(4:4) = 4 
    9{=ROW(INDIRECT("1:1")) } = {1} 
    10{=ROW(INDIRECT("1:5")) } = {1,2,3,4,5} 
    11{=ROW(INDIRECT("3:5")) } = {3,4,5} 
    		 
     Functions - R | Index - R | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top