### RANK(number, ref [,order])

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

 number The number whose rank you want to find. ref The 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.microsoft.com

 A B C 1 =RANK(10,B1:B6) = 6 10 60 2 =RANK(10,B1:B6,0) = 6 20 10 3 =RANK(10,B1:B6,1) = 1 30 30 4 =RANK(10,C1:C8) = 8 30 20 5 =RANK(10,C1:C8,0) = 8 40 50 6 =RANK(10,C1:C8,1) = 1 50 30 7 =RANK(30,B1:B6,0) = 3 some text Ge0eral 8 =RANK(20,B1:B6,0) = 5 60 30 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.