Manuals/calci/RANK

RANK(n,r,o)

• $n$ is the number to be ranked.
• $r$ is the range of numbers .
• $o$ indicates the number is ranked in ascending or descending order.

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.

Examples

Spreadsheet

	A	B	C	D	E	F	G	H
1	20	7	5	17	32
2	10	4	-1	0	15	24	45
3	4	-1	-47	-23	0	-18	1	-35

1. =RANK(7,A1:E1,0) = 4
2. =RANK(7,A1:E1,1) = 2
3. =RANK(4,A2:G2,0) = 5
4. =RANK(4,A2:G2,1) = 3
5. =RANK(-1,A2:G2,0) = 7
6. =RANK(0,A3:H3,0) = 3
7. =RANK(0,A3:H3,1) = 6
8. =RANK(-18,A3:H3,1) = 4

Related Videos

RANK

See Also

• RANKANDPERCENTILE

References

• Ranking