Documentation/Calc Functions/RANK.EQ

    From The Document Foundation Wiki

    Function name:

    RANK.EQ

    Additional details:

    The RANK.EQ function is the same as the RANK function.

    • RANK.EQ is available since LibreOffice 4.3. Take care therefore if you need compatibility.
    • This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is COM.MICROSOFT.RANK.EQ. Take care therefore if you need compatibility.

    The function name, RANK.EQ, was introduced in LibreOffice 4.3 for compatibility with Excel v.2010 and newer.

    The function name, RANK, is supported by older (and newer) versions of Excel, and by the ODF standard.

    Note pin.svg

    Note:
    The difference between RANK.AVG and RANK.EQ/RANK occurs when there are repeated numeric values in Data. The RANK.EQ/RANK function returns the same "closer-to-first" rank, whereas the RANK.AVG function returns the average rank for all the same repeated values. This means that RANK.EQ/RANK returns positive integer numbers for repeated numeric values in Data, whereas RANK.AVG may return positive non-integer numbers for such repeated numeric values in Data.

    Warning.svg

    Warning:
    Since LibreOffice 4.3 and until 7.5.2 (included), the function had an implementation error. For numeric values that are not listed within Data, the function returned numeric values, which was incorrect. Since LibreOffice 7.5.3, the implementation is correct, not only for values listed within Data. The "Examples" section includes results for the correct implementation, with a mark for cases in which an incorrect result would be obtained with the prior incorrect implementation.


    For more info, see RANK

    Examples:

    See: RANK#Examples:

    ODF standard:

    None. See instead COM.MICROSOFT.RANK.EQ

    Related (or similar) Excel functions:

    RANK.EQ since v.2010.