If you have a set data and you want to get the 2nd, 3rd, 4th,….nth largest value, you can use the LARGE function. This is a function that can help you to select a value (s) in a list based on their standing. The formula is straightforward in application.
….Where “rng” is the range of the data while “nth” is the data value you are looking.
The best application is in a class set up. Assuming you are a teacher, you have scores for students of a number of tests, how do you the nth largest value? Check out how we have used LARGE in this example:
Figure 1. Example 1 of LARGE Function
From the example, the formula in H6 is:
How the Large Formula Works
Working with the LARGE function is pretty straightforward. The function is fully automated thus all you need is to apply the range, and an integer which will specify the rank of the value you’re looking for. In the formula, H6 is the 1st largest number. That is how you are able to get the nth largest value using the LARGE function. NOTE: MAX can also be used to get the largest value.