Find the Nth Largest Value in Excel Office 365 ~ Step-By-Step Procedure!!

Normally, we can use the LARGE function to get the highest value from a range in Excel. Have you ever imagined finding the Nth largest value? Here we come up with simple and quick steps to find the N^th largest value in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Steps to find the N^th largest value:

Let’s see the below steps to get the N^th largest value in a range, you can use the below formula.

=LARGE(range,N)

Argument Explanation:

• LARGE – In Excel, the LARGE Function will help to N^th Largest value from the given range of data.

Example:

Now we are going to see how to find the largest value in Excel.

• Here, we will enter the input values in Column B.

• Then, enter the above-given formula in the formula bar section.

• Finally, you can get the result in the selected cell.

Verdict:

Hope you understood the simple steps to get the Nth largest value in Excel. Make use of it. If you have any other ideas or question , do share with us here in the comments section below. Thanks for visiting Geek Excel!! Keep Learning!!

Read Also:

• Excel Formulas to Find the Nth Largest Value with Criteria!!
• Excel Formulas to Get the Nth Matching Value Using VLOOKUP Function!!
• Formulas to Find the First Error Using MATCH function!!