RANK
Returns the rank of a number in a list of numbers.
Syntax:
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.
Example:
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.
PRODUCT & FEATURES
CAPTCHA Protection
RESOURCES
© 2023 Zapof