description:
| Rank a number against a range of numbers. |
syntax:
| =RANK( number, ref, [order] ) |
required arguments:
| number | The number to rank. |
| ref | An array that contains the numbers to rank against. |
optional arguments:
| [order] | Specify whether to rank in ascending or descending order. |
