RANK function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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
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'.
See Also
