RANK function

Returns the rank of a number in a list of numbers


 * RANK(number,ref,[order])
 * Number - the number whose rank you want to find.
 * Ref - an array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored.
 * Order - a number specifying how to rank number.
 * If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order.
 * If order is any nonzero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order.
 * RANK gives duplicate numbers the same rank. However, the presence of duplicate numbers affects the ranks of subsequent numbers. For example, in a list of integers sorted in ascending order, if the number 10 appears twice and has a rank of 5, then 11 would have a rank of 7 (no number would have a rank of 6).