Excel Formulas to Get the Name of Nth Largest Value!!
Tags: excelformula, excelformulas
Published: 2020-12-15 09:19:26

---
title: Excel Formulas to Get the Name of Nth Largest Value!!
published: true
date: 2020-12-14 10:50:04 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-get-name-nth-largest-value/
---

For instance, you have a range of data that contains the name column with the corresponding score column and, you want to get the name of the person who scored highest, how could you find it? This article provides some simple formulas to **get the**  **Name of N<sup>th</sup> largest value in Excel**. 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 name of the Nth largest value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-find-name-of-the-Nth-largest-value.png)](https://geekexcel.com/excel-formulas-get-name-nth-largest-value/formulas-to-find-name-of-the-nth-largest-value/#main)<figcaption id="caption-attachment-19640">Formulas to find the name of the Nth largest value</figcaption>
## General Formula:

- Use the below formula to find the name of the largest value in Excel.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(names,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)([LARGE](https://geekexcel.com/how-to-use-excel-large-function-in-office-365-with-examples/)(values,N),values,0))**

## Syntax Explanations:

- **INDEX** – In Excel, The **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** returns the value at a given position in a range or array.
- **MATCH** – It helps to locate the position of a lookup value in a row, column, or table. Read more on the **[MATCH Function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)**.
- **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/)**.
- **Names** – It represents the input names from the given worksheet.
- **Values** – It is the range of cells that contain values.
- **N** – It represents the N<sup>th</sup> largest value.

## Example:

- In the below example, we are going to find the name of the person who scored the highest mark.
- Here, we will give the input names in **Column B** and give the corresponding scores in  **Column C**.
- After that, we define the name for the input ranges like **Names** and **Values.**
- Then, enter the given formula in the selected area.
- Finally, we will get the result in **Cell F3**.

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

## Wrap-Up:

Hope you understood the simple formulas used to **get the name of the Nth largest value in Excel**. If you have any other **ideas** or **question,** do share with us here in the **comments** section below. We will assist you. To learn more, check out our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Get the Largest Value with Criteria!!](https://geekexcel.com/excel-formulas-to-get-the-largest-value-with-criteria/)**
- [**Excel Formulas to Calculate the Average of Top N Values from a set of Data!!**](https://geekexcel.com/excel-formulas-to-calculate-the-average-of-top-n-values/)

### Video Tutorial:

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