Excel Formulas to Rank the Values based on Month ~ Simple Tricks!!
Tags: excelformula, excelformulas
Published: 2021-04-21 10:23:15

---
title: Excel Formulas to Rank the Values based on Month ~ Simple Tricks!!
published: true
date: 2021-04-12 07:01:04 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-rank-the-values-based-on-month/
---

For instance, we have a list of names with dates and amounts. Now we need to display the list of names and amounts, that are ranked by a numeric value. In this article, we will show the simple trick to **rank the values based on the month 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)

![Rank values by month](https://geekexcel.com/wp-content/uploads/2021/04/Rank-values-by-month.png)<figcaption id="caption-attachment-26494">Rank values by month</figcaption>


## General Formula:

- If you want to rank the values based on month, use the below formula.

**To Rank the Amount = =[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/)([TEXT](https://geekexcel.com/list-of-text-functions-in-microsoft-excel-365/)(date,”mmmm”)=[G$4](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/),amount),$F5)**

**To Rank the Names = =[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(name,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(1,(amount=G5)\*([TEXT](https://geekexcel.com/list-of-text-functions-in-microsoft-excel-365/)(date,”mmmm”)=G$9),0))**

## Syntax Explanations:

- **LARGE** – In Excel, the **[LARGE Function](https://geekexcel.com/how-to-use-excel-large-function-in-office-365-with-examples/)** will help to return the Nth Largest value from the given range of data.
- **IF** – This function will return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result. Read more on the **[IF Function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)**.
- **TEXT** – [**Text Function**](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/) in Excel will help you to convert a number to text in the given format.
- **INDEX** – The **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** helps to return the value at a given position in a range or array
- **MATCH** – This function will 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/)**.
- **Absolute Reference ($)** – The [**Absolute Reference**](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/) is an actual fixed location in a worksheet.
- **Name** – It represents the input names from your worksheet.
- **Date** – It represents the input dates from your worksheet.
- **Amount** – It represents the input amounts from your 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.
- **Multiplication (\*)** – In this symbol will multiply any two values or numbers.

## Example:

Let’s consider the below example image.

- First, we will enter the input values in **Column B** to **Column D**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-13.png)<figcaption id="caption-attachment-26498">Input Ranges</figcaption>

- Now enter the first formula in **cell G3**.

![Enter a formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-a-formula.png)<figcaption id="caption-attachment-26514">Enter a formula</figcaption>

- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- It will display the result as shown below.

![Result 1](https://geekexcel.com/wp-content/uploads/2021/04/Result-1-1.png)<figcaption id="caption-attachment-26496">Result 1</figcaption>

- Now we are going to find the names for the specified amount.

![Criteria](https://geekexcel.com/wp-content/uploads/2021/04/2nd-criteria.png)<figcaption id="caption-attachment-26516">Criteria</figcaption>

- Enter the second formula in **cell G8**.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-2.png)<figcaption id="caption-attachment-26515">Enter the formula</figcaption>

- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- It will display the result as shown below.

![Result 2](https://geekexcel.com/wp-content/uploads/2021/04/Result-2-1.png)<figcaption id="caption-attachment-26497">Result 2</figcaption>

## Verdict:

Hope you like this article on how to **rank the values based on the month in Excel**. Please share your **query** below in the **comment** box. We will assist you. Thank you so much for visiting our site!! Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Article:

- **[Excel Formulas to Highlight the Values Not Between X and Y!!](https://geekexcel.com/excel-formulas-to-highlight-the-values-not-between-x-and-y/)**
- **[Excel Formulas to Highlight the Integer Values Only ~ A Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-highlight-the-integer-values-only/)**