Skip to content

Klargrid

The LARGE function

The second, third, tenth largest value: enough to build a leaderboard.

Syntax

=LARGE(array, k)

In a French Excel: =GRANDE.VALEUR(matrice; k).

Arguments

array: the values.
k: 1 for the largest, 2 for the next…

An example

=LARGE($C$2:$C$500,ROW()-1)

Copied down ten rows from row 2: the ten largest values, in order.

Pitfalls

k greater than the number of values: #NUM!.
Text is ignored.

Going further

RANK.EQ, MAX.
SORT, which returns the whole table sorted in Excel 365.

Frequently asked questions

How do I get the name that goes with the value?: =INDEX($A$2:$A$500,MATCH(LARGE($C$2:$C$500,1),$C$2:$C$500,0)), or SORT in Excel 365.