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 retrieve "nth largest" values - 1st largest value, 2nd largest value, 3rd largest 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.
Version 
Usage notes 

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

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. 

To get nth smallest values, see the SMALL function.

Example

To retrieve the 1st, 2nd, and 3rd largest values in a range:

=LARGE(range,1) // 1st largest value
=LARGE(range,2) // 2nd largest value
=LARGE(range,3) // 3rd largest value

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.