This problem can be solved with the LARGE function.

Note: I don’t know why the second argument for LARGE is called “k” .

LARGE function

TheLARGE functioncan be used to return the nth largest value in a set of data.

Nth largest value - basic example

The official names for these arguments are “array” and “k”.

Nth largest value - basic example

Nth largest value - basic example

Nth largest value - basic example

Nth largest value - basic example

Excel formula: Name of nth largest value

Excel formula: nth largest value with criteria

Excel formula: nth smallest value

Excel formula: Sum top n values

Excel formula: Average top 3 scores

Excel LARGE function

Article image

Article image