| | | 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 a working example please refer to the Functions Advanced > RANK Function page. |
| | | Example 1 - What is the rank of the number 10 in the list "B1:B6". |
| | | Example 2 - What is the rank of the number 10 in the list "B1:B6" when the largest number has a rank of 1. |
| | | Example 3 - What is the rank of the number 10 in the list "B1:B6" when the smallest number has a rank of 1. |
| | | Example 4 - What is the rank of the number 20 in the list "C1:C8" |
| | | Example 5 - What is the rank of the number 20 in the list "C1:C8" when the largest number has a rank of 1. |
| | | Example 6 - What is the rank of the number 20 in the list "C1:C8" when the smallest number has a rank of 1. |
| | | Example 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. |
| | | Example 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. |
| | | Example 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. |
| | | Example 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. |
| | | Example 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. |
| | | Example 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. |
| | | | 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 | ????? | | | | 14 | =RANK(40,B1:B6,1) = 5 | | | | 15 | =RANK(50,B1:B6,1) = 6 | | | | 16 | =RANK(60,B1:B8,1) = 7 | | | | 17 | =RANK(40,B1:B2,1) = #N/A | | |
| |