Documentation/Calc Functions/RANK.EQ

From The Document Foundation Wiki
Jump to: navigation, search


Under construction.
For now, see the system Help files.

Function name:



Statistical Analysis


Returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, these are given the same rank.


RANK.EQ(Value; Data; Type)



Value is the value, whose rank is to be determined.

Data is the array or range of data in the sample.

Type (optional) is the sequence order. Type = 0 means descending from the last item of the array to the first (this is the default), Type = 1 means ascending from the first item of the range to the last.

Additional details:

The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank.


=RANK.EQ(A10;A1:A50) returns the ranking of the value in A10 in value range A1:A50. If Value does not exist within the range an error message is displayed.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: