RANK(number, ref [,order])

Returns the rank of a value in a list, table or cell range (in descending order) (equal ranking).

numberThe number whose rank you want to find.
refThe array, or a reference to, a list of numbers.
order(Optional) The number indicating how the list of numbers is sorted:
0 = largest number has a rank of 1 (default)
1 = smallest number has a rank of 1

Remarks

* RANK.EQ was added in Excel 2010 to replace this function.
* Any duplicate numbers in the list will have the same rank.
* The "ref" does not have to be sorted into any particular order.
* 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 an illustrated example refer to the page under Advanced Functions.
* For the Microsoft documentation refer to support.office.com

 ABC
1=RANK(10,B1:B6) = 61060
2=RANK(10,B1:B6,0) = 62010
3=RANK(10,B1:B6,1) = 13030
4=RANK(10,C1:C8) = 83020
5=RANK(10,C1:C8,0) = 84050
6=RANK(10,C1:C8,1) = 15030
7=RANK(30,B1:B6,0) = 3some textGe0eral
8=RANK(20,B1:B6,0) = 56030
9=RANK(30,B1:B6,1) = 3  
10=RANK(20,B1:B6,1) = 2  
11=RANK(30,C1:C8,0) = 3  
12=RANK(20,C1:C8,0) = 6  
13=RANK(40,B1:B6,1) = 5  
14=RANK(50,B1:B6,1) = 6  
15=RANK(60,B1:B8,1) = 7  
16=RANK(40,B1:B2,1) = #N/A  

1 - What is the rank of the number 10 in the list "B1:B6".
2 - What is the rank of the number 10 in the list "B1:B6" when the largest number has a rank of 1.
3 - What is the rank of the number 10 in the list "B1:B6" when the smallest number has a rank of 1.
4 - What is the rank of the number 20 in the list "C1:C8"
5 - What is the rank of the number 20 in the list "C1:C8" when the largest number has a rank of 1.
6 - What is the rank of the number 20 in the list "C1:C8" when the smallest number has a rank of 1.
7 - What is the rank of the number 30 in the list "B1:B6" {50,40,30,30,20,10} when the largest number has a rank of 1.
8 - What is the rank of the number 20 in the list "B1:B6" {50,40,30,30,20,10} when the largest number has a rank of 1.
9 - What is the rank of the number 30 in the list "B1:B6" {10,20,30,30,40,50} when the smallest number has a rank of 1.
10 - What is the rank of the number 20 in the list "B1:B6" {10,20,30,30,40,50} when the smallest number has a rank of 1.
11 - What is the rank of the number 30 in the list "C1:C8" {60,50,30,30,30,20,20,10} when the largest number has a rank of 1.
12 - What is the rank of the number 20 in the list "C1:C8" {60,50,30,30,30,20,20,10} when the largest number has a rank of 1.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top