Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > RANK

 

RANK(number, ref [,order])

 
 Returns the rank of a number in a list of numbers.

 numberThe number whose rank you want to find.
 refThe array, or a reference to, a list of numbers.
 orderThe number indicating how the list of numbers is sorted:
0 = "ref" is sorted in descending order
1 = "ref" is sorted in ascending order

 REMARKS
 
  • The presence of any duplicate numbers will affect the rank of any subsequent numbers.
     
  • If "ref" contains any non numeric values, then these are ignored. See Example 12.
     
  • If "order" = "0", then the smallest numbers are given the largest rank.
     
  • If "order" = "1", then the largest numbers are given the largest rank.
     
  • If "order" is left blank, then 0 is used.
     
  • Any duplicate numbers are given the same rank. See Example 4.
     
  • For a working example please refer to the RANK Function page.

     EXAMPLES
     
     AB
    1=RANK(10,B1:B6) = 610
    2=RANK(10,B1:B6,0) = 620
    3=RANK(20,B1:B6,0) = 530
    4=RANK(30,B1:B6,0) = 330
    5=RANK(40,B1:B6,0) = 240
    6=RANK(50,B1:B6,0) = 150
    7=RANK(10,B1:B6,1) = 1some text
    8=RANK(20,B1:B6,1) = 260
    9=RANK(30,B1:B6,1) = 3 
    10=RANK(40,B1:B6,1) = 5 
    11=RANK(50,B1:B6,1) = 6 
    12=RANK(60,B1:B8,1) = 7 
    13=RANK(40,B1:B2,1) = #N/A 
     

     Functions - R | Index - R | Office Online 

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