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.
Version 
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.

Download 200+ Excel Shortcuts

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