nth largest value

An excel formula to nth largest value


Related Functions

 nth largest value

To get the 2nd largest value, 3rd largest value, 4th largest value, and so on, from a set of data, you can use the LARGE function.

In the example shown, the formula in J5 is:


How this formula works

The LARGE function is fully automatic — you just need to supply a range and an integer for"nth" to specify the ranked value you want.

The official names for these arguments are "array" and "k".

Note: you can also use the MAX function to get the largest value (i.e. the largest value).

0 votes. 0 / 5