Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelHow to find the Nth Largest Numbers from a List of values in Excel ?

# How to find the Nth Largest Numbers from a List of values in Excel ?

There are times when you might want to find out the 3rd Largest value from the list of number from Excel cells.

# How to find the N Largest Numbers from a List of values in Excel ?

Microsoft Excel provides the function LARGE which lets you to this.

The function LARGE takes 2 parameters.
â€“ The first parameter takes the range of cells.
â€“ The second parameter specifies the nth Largest value that you are searching for.

Assume that the Excel Column (A1:A7) contains the range of values , you would need to find the 3rd Largest value from this range and display it in the cell B1.

Just enter the following formula in the cell B1.

=LARGE(A1:A7,3)

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021