LARGE

Get the nth largest value

LARGE

Summary 

The 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, 4th largest value, 5th 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.

Usage notes 

The LARGE function is useful when you want to retrieve "top" values from a set of data. For example, the first, second, and third results in a competition.

array can be an array constant or a range of cells.

n is the position away from the largest value. For example, use 2 for the 2nd largest value, 3 for the 3rd largest value, etc.

Microsoft uses "k" instead of "n" in their function documentation. Exceljet uses n because "nth" is more familiar than "kth".

0 votes. 0 / 5