Excel Function Translator Logo
    The Excel Translator

    RANK

    Statistical

    Returns the rank of a number in a list of numbers.

    Translations
    EnglishRANK
    FrenchRANG
    SpanishJERARQUIA
    GermanRANG
    ItalianRANGO
    PortugueseORDEM
    DutchRANG
    PolishPOZYCJA
    RussianРАНГ
    TurkishDERECE
    CzechRANK
    HungarianRANG
    SwedishRANG
    DanishPLADS
    FinnishARVON.MUKAAN
    Syntax
    RANK(number, ref, [order])

    Arguments

    • numberNumber to rank
    • refRange of numbers
    • order0=descending (default), 1=ascending(optional)
    Examples
    =RANK(A1,$A$1:$A$100)
    Position

    Rank from highest

    =RANK(A1,$A$1:$A$100,1)
    Ascending rank

    Rank from lowest

    =RANK(B2,Scores)
    Score ranking

    Rank within named range

    Tips & Best Practices
    • •Duplicate values get the same rank
    • •Use RANK.AVG for average ranking of ties
    • •Lock the reference range with $
    Common Mistakes
    • •Forgetting to lock the reference range with $ signs when copying the formula down, which shifts the comparison range for each row instead of keeping it fixed
    • •Not specifying the order argument and assuming it defaults to the order you want - 0 (or omitted) ranks descending, 1 ranks ascending, easy to mix up
    • •Expecting RANK to handle ties by splitting the rank, when it actually gives duplicate values the same (best) rank and skips the next rank number entirely
    Related Functions
    RANK.EQThe modern replacement for RANK, behaving identically but with clearer naming to distinguish it from RANK.AVG.
    LARGEReturns the value at a given rank position, rather than telling you the rank of an existing value.
    SMALLReturns the value at a given rank position counting from the smallest, the mirror image of LARGE.
    Frequently Asked Questions

    Why does my RANK formula give the wrong result when copied down?

    The reference range probably isn't locked with $ signs, so it shifts down with each row instead of staying fixed on the full data set.

    How does RANK handle tied values?

    Tied values get the same rank, and the next rank number is skipped entirely. If two values tie for rank 2, the next distinct value gets rank 4, not 3.

    Should I use RANK or RANK.EQ?

    RANK.EQ is the modern equivalent and works identically - RANK is kept only for backward compatibility with older files.

    Need to translate a formula using RANK?

    Use our translator to convert your complete formula