Manuals/calci/RANK

RANK(n,r,o)

Description

This function gives the rank of a given set of numbers.
It is based on the value of a number, relative to the other numbers in the list.
In $RANK(n,r,o)$ , $n$ is the number to be get ranked, $r$ is the range of the cells to find the ranking the number and $o$ indicates the number is ranked in ascending or descending order.
If $o$ is zero, then the list of the numbers getting in descending order.
If $o$ is 1, then the list of the numbers getting in ascending order.
When we are not mentioning the $o$ value, then it will give the set of numbers in descending order.
$RANK$ gives the spare numbers that having the same rank.
The occurrence of the spare number affects the ranks of the next numbers.
This function will return the result as error when any one of the argument is non-numeric.