Excel Formulas to Find the Nth Largest Value without Duplicates!!
Tags: excelformula, excelformulas
Published: 2020-12-16 03:50:47

---
title: Excel Formulas to Find the Nth Largest Value without Duplicates!!
published: true
date: 2020-12-15 11:04:33 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-nth-largest-without-duplicates/
---

In an Excel worksheet, we can get the largest, the second-largest, or nth largest value by applying the Large function. But, if there are duplicate values in the list, this function will not skip the duplicates when extracting the nth largest value. In this case, how could you **get the nth largest value without duplicates in Excel**?

Today I introduce you to some formulas to solve this problem. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to find the nth largest without duplicate](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-find-the-nth-largest-without-duplicate.png)](https://geekexcel.com/excel-formulas-nth-largest-without-duplicates/formulas-to-find-the-nth-largest-without-duplicate/#main)<figcaption id="caption-attachment-19755">Formulas to find the nth largest without duplicate</figcaption>
## General Formula:

- Use the below formula to find the largest N values without duplicates.

**=[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(range<A2,range))**

## Syntax Explanations:

- **MAX** – In Excel, this function will return the largest numeric value from the range of input values. Read more on the [**MAX Function**](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/).
- **IF** – The Excel **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** will help to return one value for a TRUE result, and another for a FALSE result.
- **Range** – It represents the input values from the given worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- Now, we are going to see how to find the Nth largest value without duplicates.
- Refer to the below image.
- Here, we will give the input values in **Column B**.
- First, we want to get the largest value using the MAX Function in **Cell E3**. Using the formula **=MAX(range)**.
- Then, enter the given formula in **Cell E4**.
- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- Finally, it displays the result in the selected cell.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-56.png)<figcaption id="caption-attachment-19754">Example</figcaption>

## Conclusion:

Hope you understood the formula to **find the**  **Nth largest value without duplicates in Excel**. Leave a **comment** or **reply** below – let me know what you think! I reply to **queries** frequently. To know further updates keep in touch with **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Get the Name of Nth Largest Value!!](https://geekexcel.com/excel-formulas-get-name-nth-largest-value/)**
- **[Excel Formulas to Find the Maximum Value of Every Nth Column!!](https://geekexcel.com/excel-formulas-find-the-maximum-number-or-every-nth-column/)**

### Video Tutorial:

<!--[if lt IE 9]><script>document.createElement('video');</script><![endif]--><video id="video-19749-1" width="770" height="550" loop="1" autoplay="1" preload="metadata" controls="controls"><source type="video/webm" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Adyzauqy60-1.webm?_=1"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Adyzauqy60-1.webm">https://geekexcel.com/wp-content/uploads/2020/12/Adyzauqy60-1.webm</a></video>