Excel Formulas Used to Group the Numbers at Uneven Intervals!!
Tags: excelformula, excelformulas
Published: 2021-03-05 11:40:00

---
title: Excel Formulas Used to Group the Numbers at Uneven Intervals!!
published: true
date: 2021-03-05 06:53:07 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-group-numbers-at-uneven-intervals/
---

So far we have learned many formulas using the Lookup function. This tutorial shows **how to group the numbers at uneven intervals in Excel by using the Lookup function**. 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)

[![Group Uneven intervals](https://geekexcel.com/wp-content/uploads/2021/03/Group-Uneven-intervals.png)](https://geekexcel.com/excel-formulas-group-numbers-at-uneven-intervals/group-uneven-intervals/#main)<figcaption id="caption-attachment-22241">Group Uneven intervals</figcaption>

## Generic Formula:

- Use the below formula to group the uneven interval values in Excel.

**=[LOOKUP](https://geekexcel.com/use-lookup-function-in-microsoft-excel-365-simple-methods/)(value, intervals,groups)**

## Syntax Explanations:

- **LOOKUP** – The [**LOOKUP Function**](https://geekexcel.com/use-lookup-function-in-microsoft-excel-365-simple-methods/) in Excel performs an approximate match lookup in a one-column or one-row range and returns the corresponding value from another one-column or one-row range
- **Value** – It represents the criteria value for the input values.
- **Intervals** – It represents the input data given.
- **Groups** – It represents the input table value.
- **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.
- 

## Practical Example:

Refer to the below example image.

- Here, we will give the input values in **Column B** and **Column C**.
- Now we are going to group the numbers at uneven intervals based on the given table in **Column F** and **Column G**.

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

- Apply the above-given formula to the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section and press the **“Enter”** key.

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

- Finally, it will display the result as per the below image.

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

## Closure:

From this tutorial, you can easily understand the simple formulas used to **group the**  **numbers at uneven intervals in Excel**. Hope you like this article. Please state your **queries** in the below comment section. To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Formulas to Count with COUNTIF Function in Excel Office 365!!](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)**
- **[Excel Formulas: IF Function with Other Calculations!!](https://geekexcel.com/excel-formulas-if-function-with-other-calculations/)**
- **[Formulas to Count with COUNTIF Function in Excel Office 365!!](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)**
- **[Excel Formulas To Find the Value Based on Nested IF Condition!!](https://geekexcel.com/excel-formulas-to-find-the-value-based-on-nested-if-condition/)**