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: