Excel Formulas to Find the Nth Largest Value with Criteria!!
Tags: excelformula, excelformulas
Published: 2020-12-16 03:50:14

---
title: Excel Formulas to Find the Nth Largest Value with Criteria!!
published: true
date: 2020-12-15 11:01:47 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-nth-largest-value-with-criteria/
---

For instance, you have a list that contains data like names, gender, and scores, If you want to find the highest score based on gender, what would you do?

In this tutorial, we are going to look at how to **find the N<sup>th</sup> largest value based on certain criteria 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](https://www.microsoft.com/en-in/microsoft-365/excel)

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

- The below formula will help to find the N<sup>th</sup> largest value with criteria.

**=[LARGE](https://geekexcel.com/how-to-use-excel-large-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(range=criteria,values),N)**

## Syntax Explanations:

- **LARGE** – This function returns the N<sup>th</sup> largest value from the given range of data. Read more on the **[LARGE Function](https://geekexcel.com/how-to-use-excel-large-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.
- **N** – It represents the N<sup>th</sup> largest values.

## Example:

- Let’s consider the below example image to find the N<sup>th</sup> largest values based on criteria.
- Here, we will give the input values in **Column C** and **Column D**.
- After that, enter the given formula in the formula bar section.
- Finally, we will get the result in **cell H3**.

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

## Wrap-Up:

From this guide, you can easily understand the simple formulas to **find the N<sup>th</sup> largest values based on certain criteria in Excel**. Let me know if you have any **doubts** regarding this article or any other article on this site. To learn more, check out our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[How to Extract the N<sup>th</sup> Word From a Text String in Excel 365 ](https://geekexcel.com/how-to-extract-the-nth-word-from-a-text-string-in-excel-365-with-kutools/)**
- **[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:

<video id="video-19733-4" width="770" height="393" 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/28Fcrilaqi-1.webm?_=4"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/28Fcrilaqi-1.webm">https://geekexcel.com/wp-content/uploads/2020/12/28Fcrilaqi-1.webm</a></video>