Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get Expert help in seconds.

Your message must be at least 40 characters
Our professional Expert are available now. Your privacy is guaranteed.

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:

=LARGE(rng,nth)

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

=LARGE($C6:$F6,1)

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.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get Expert help in seconds.

Your message must be at least 40 characters
Our professional Expert are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc