Excel Formulas to Find the Nth Largest Value From a set of data!!
Tags: excelformula, excelformulas
Published: 2020-12-16 03:50:25

---
title: Excel Formulas to Find the Nth Largest Value From a set of data!!
published: true
date: 2020-12-15 11:02:32 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-nth-largest-value/
---

Have you ever tried to get the N<sup>th</sup> largest value in Excel? This article will introduce several tricks to solve them in Excel easily.

Here we will show the simple **formulas to find the N<sup>th</sup> largest values from a set of data 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-find-the-Nth-largest-value.png)](https://geekexcel.com/excel-formulas-nth-largest-value/formulas-to-find-the-nth-largest-value/#main)<figcaption id="caption-attachment-19727">Formulas to find the Nth largest values</figcaption>
## General Formula:

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

**=[LARGE](https://geekexcel.com/how-to-use-excel-large-function-in-office-365-with-examples/)(range, 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/)**.
- **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.
- Here, we will give the input values in **Column C** to **Column G**.
- After that, enter the given formula in the formula bar section.
- Finally, we will get the result in **cell I4**.

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

## Wrap-Up:

From this guide, you can easily understand the simple formulas to **find the N<sup>th</sup> largest values 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/) **!!** Thank You!

### 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-19722-3" width="770" height="391" 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/Ipcl57lmbk-1.webm?_=3"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Ipcl57lmbk-1.webm">https://geekexcel.com/wp-content/uploads/2020/12/Ipcl57lmbk-1.webm</a></video>