< Go Back

nth largest value

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.

Generic Formula:


….Where “rng” is the range of the data while “nth” is the data value you are looking.

Application Example

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.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment