Excel Formulas To Find Multiple cells are equal In Excel 365!!
Tags: excelformula, excelformulas
Published: 2021-10-25 02:19:01

---
title: Excel Formulas To Find Multiple cells are equal In Excel 365!!
published: true
date: 2021-10-22 09:11:25 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-multiple-cells-are-equal-in-excel-365/
---

So far we have learned the formulas to **[test multiple cells and return Non-Blank values](https://geekexcel.com/excel-formulas-multiple-cells-and-return-non-blank-value/)**in Excel. Likewise, here we are going to **find the multiple cells that are equal in Excel**  **365**. Let’s get 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)

## Generic Formula

- You can use the below-mentioned formula to find the **multiple cells that are equal** in Excel.

```
{=[AND](https://geekexcel.com/how-to-use-logical-function-and-in-excel-365/)(range1=range2)}

```

## Syntax Explanation

- **AND** – It is used to check more than **one logical condition** at the same time
- **Range 1 & 2 ** – It represents the **input ranges**.
- **Parenthesis ()** – The purpose of this symbol is to **group the elements**.
- **Curly braces {}** – It is an **array formula** carries out calculations on **one or more elements** in an array.

## Practical Example1

Let’s consider the below example. Here we are going to find the multiple cells that are equal.

- For instance, you have to **create the input values** in **Column B to Column D as Range 1** and **Column F to Column H as Range 2** as shown in the below image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Sample-data-39.png)<figcaption>Sample data</figcaption>

- Here, you need to **find** out the **multiple cells that are equal**.
- Then, you have to apply the below-given formula to the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section and hit  **Ctrl+Shift+Enter**   **key**.

```
{=[AND](https://geekexcel.com/how-to-use-logical-function-and-in-excel-365/)(B5:D12=F5:H12)}

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-Formula.png)<figcaption>Use the Formula</figcaption>

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

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Output-38.png)<figcaption>Output</figcaption>

## Practical Example2

- For instance, you have to **create the input values** in **Column B to Column D as Range 1** and **Column F to Column H as Range 2** as shown in the below image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Ex-Sample-data-4.png)<figcaption>Sample data</figcaption>

- Here, you need to **find** out the **multiple cells that are equal**.
- Then, you have to apply the below-given formula to the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section and **hit Ctrl+Shift+Enter key**.

```
{=[AND](https://geekexcel.com/how-to-use-logical-function-and-in-excel-365/)(B5:D12=F5:H12)}

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Ex-Use-the-Formula.png)<figcaption>Use the formula</figcaption>

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

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Ex-Output-4.png)<figcaption>Output</figcaption>

## Bottom-Line

In this article, we guided you to know how to **find the multiple cells that are equal in Excel**  **365** with proper examples and screenshots. Kindly, give your **feedback** in the below comment section.

Thanks for visiting **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Further Reference:**

- **[Formulas to Count the Cells contains Not Equal to a Particular Value!!](https://geekexcel.com/formulas-to-count-the-cells-contains-not-equal-to-a-particular-value/)**
- **[Excel Formulas to Sum the Values if Cells are Equal to Specific Value!!](https://geekexcel.com/excel-formulas-to-sum-the-values-if-cells-are-equal-to-specific-value/)**
- **[Excel Formulas to Sum the Values if Cells are Not Equal to Certain Value!!](https://geekexcel.com/excel-formulas-to-sum-the-values-if-cells-are-not-equal-to-certain-value/)**
- **[Use Excel PROPER Function in Office 365 – Simple methods!!](https://geekexcel.com/use-proper-function-in-microsoft-excel-2013-simple-methods/)**
- **[Excel formulas to Find IF Cells Equal to a Certain Value!! ](https://geekexcel.com/excel-formulas-to-find-if-cells-equal-to/)**