Returns the rank of a number in a list of numbers.


RANK(number, numberlist, order)

returns the rank of number within the unordered range or array of numbers numberlist.
If order is zero or omitted, numbers are ranked with the highest being first; if order is non-zero, numbers are ranked with the lowest being first.
An error results if number is not present in numberlist.


RANK(5, B1:B4)
where cells B1, B2, B3, B4 contain 4, 7, 5,and 8, returns 3. The highest number is 8, then 7, then in third place 5.
RANK(5, {3,5;2.6,1}, 1)
returns 4, as the other three numbers are lower than 5.

Created with Zapof