How to get nth largest value in Excel

Use the LARGE function to get the nth largest value from a set of values e.g. 2nd largest, 3rd largest, and, so on. In our example, we will largest and second largest values.

How the formula works

The formula used to find the largest value in the example is:

=LARGE(A5:D5,1)  where,

array (A5:D5) – The range of cells to find the largest value as per criteria.

k (1) –  The nth largest value e.g 2nd larget, 3rd largest and so on.

To find 2nd largest value, change k value to “2” and remaining formula will be unchanged:

=LARGE(A5:D5,2)

Example

Formula:

Result:

Copy and paste the formula into other cells.

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved