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:
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: