Excel Function Translator Logo
    The Excel Translator

    LARGE

    Statistical

    Returns the k-th largest value in a data set.

    Translations
    EnglishLARGE
    FrenchGRANDE.VALEUR
    SpanishK.ESIMO.MAYOR
    GermanKGRÖSSTE
    ItalianGRANDE
    PortugueseMAIOR
    DutchGROOTSTE
    PolishMAX.K
    RussianНАИБОЛЬШИЙ
    TurkishBÜYÜK
    CzechVELKÝ
    HungarianNAGY
    SwedishSTÖRSTA
    DanishSTOR
    FinnishSUURI
    Syntax
    LARGE(array, k)

    Arguments

    • arrayRange of data
    • kPosition from the largest
    Examples
    =LARGE(A1:A100,1)
    Maximum

    Same as MAX

    =LARGE(A1:A100,2)
    2nd largest

    Second highest value

    =LARGE(Scores,3)
    3rd place

    Bronze medal score

    Tips & Best Practices
    • •LARGE(range,1) equals MAX(range)
    • •Use with ROW for dynamic rankings
    • •Returns #NUM! if k exceeds data count
    Common Mistakes
    • •Passing a k value larger than the number of items in the array, which returns a #NUM! error instead of some kind of empty result
    • •Forgetting LARGE counts duplicates separately - if the top two values are tied, LARGE(range,1) and LARGE(range,2) both return that same tied value
    • •Using LARGE on a range containing errors expecting them to be ignored automatically - LARGE handles text and blanks fine, but an actual error value in the range will break it
    Related Functions
    SMALLReturns the k-th smallest value instead of the k-th largest, the mirror function.
    RANKTells you the rank of a specific value, rather than the value at a specific rank.
    MAXReturns just the single largest value, a simpler version of LARGE(range,1).
    Frequently Asked Questions

    What happens if k is bigger than the count of values in my range?

    LARGE returns a #NUM! error - there's no 10th largest value in a 5-item list, for example.

    Does LARGE skip duplicate values?

    No, it counts every value including ties. If the top two numbers are both 100, LARGE(range,1) and LARGE(range,2) both return 100.

    What's the difference between LARGE(range,1) and MAX(range)?

    They return the same result - LARGE with k=1 is just a more flexible version of MAX that can also get the 2nd, 3rd, or nth largest value.

    Need to translate a formula using LARGE?

    Use our translator to convert your complete formula