Excel Formulas to Find the Position of Nth Matching Value!!
Tags: excelformula, excelformulas
Published: 2021-01-18 03:52:56

---
title: Excel Formulas to Find the Position of Nth Matching Value!!
published: true
date: 2021-01-05 15:30:57 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-position-of-nth-matching-value/
---

At some points, we need to **find the [position of Nth matching value](https://geekexcel.com/excel-formulas-get-position-of-last-matching-value/) in Excel**. How can you calculate them quickly? 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 get the position of Nth match value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Formulas-to-get-the-position-of-Nth-match-value.png)<figcaption id="caption-attachment-20690">Formulas to get the position of Nth match value</figcaption>
## General Formula:

- To get the position of the nth matching value in Excel, you can use the below formula.

**=[SMALL](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(logical,[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(list)-[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(ROW(list))+1),n)**

## Syntax Explanations:

- **SMALL** – This function returns the [N<sup>th</sup> smallest value from the given range of data](https://geekexcel.com/excel-formulas-find-nth-smallest-value/). Read more on **[SMALL Function](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)**.
- **IF** – The Excel[**IF function**](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/) return one value for a TRUE result, and another for a FALSE result.
- **ROW** – It will return the row number for reference. Read more on the **[ROW function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)**.
- **MIN** – In Excel, the **[MIN Function](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)** returns the smallest numeric value from the range of input values.
- **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.
- **List** – It represents the input ranges in your worksheet.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Plus operator (+)** – This symbol is used to add the values.

## Practical Example:

- Now we are going to see how to find the location of the nth value.
- First, we will give the input ranges in **Column C** and **Column C**.
- Then, enter the given formula in the formula bar section.
- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- Finally, we will get the result in **Cell G4**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Example-2.png)<figcaption id="caption-attachment-20689">Example</figcaption>

## Verdict:

Hope you understood the simple steps to find the **position of Nth matching value in Excel**. If you have any other **ideas** or **question,** do share with us here in the **comments** section below. Click here to know more on **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Find the Nth Smallest Value from a Range!!](https://geekexcel.com/excel-formulas-find-nth-smallest-value/)**
- **[Excel Formulas to Find the Maximum Value From a Given Month!!](https://geekexcel.com/excel-formulas-find-maximum-value-from-given-month/)**
- [**Formulas to Sum the values by month in Excel Office 365!!**](https://geekexcel.com/formulas-to-sum-the-values-by-month-in-excel-office-365/)