Exceljet

Quick, clean, and to the point

Excel LARGE Function

Excel LARGE function
Summary 

The Excel LARGE function returns numeric values based on their position in a list when sorted by value. In other words, it can retrive "nth largest" values - largest value, 2nd largest value, 3rd lagest value, etc.

Purpose 
Get the nth largest value
Return value 
The nth largest value in the array.
Syntax 
=LARGE (array, n)
Arguments 
  • array - The array from which you want to select the kth largest value.
  • n - An integer that specifies the position from the largest value, i.e. the nth position.
Usage notes 

The LARGE function is useful when you want to retrieve the nth highest value from a set of data — for example, the first, second, or third highest scores for a test. Like the SMALL function, the LARGE function retrieves numeric values based on their position in a list when sorted by value.

Note: Microsoft documentation refers to "k" instead of "n". We use n because "nth" is much easier to say.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.