Manuals/calci/RANK

RANK(n,r,o)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is the number to be ranked.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r} is the range of numbers .
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} indicates the number is ranked in ascending or descending order.
• If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} is zero, then the list of the numbers getting in descending order.
• If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} is 1, then the list of the numbers getting in ascending order.
• When we are not mentioning the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} value, then it will give the set of numbers in descending order.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 nonnumeric.

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