RANK function
From Apache OpenOffice Wiki
< Documentation | How Tos
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
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.
Issues:
- By design, RANK returns the same rank for any value that is repeated in numberlist. If you wish a unique rank for each number in (say) A1:A4, enter =RANK(A1;$A$1:$A$4)+COUNTIF($A$1:A1;A1)-1 in cell B1 and copy/paste into B2:B4.
- Calc assumes that any logical values are 1 (TRUE) and 0 (FALSE). Excel's behavior with logical values may be 'unexpected'.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}