How to Check Multiple columns are equal in excel office 365?
Tags: excelformula, excelformulas
Published: 2021-10-25 02:19:18

---
title: How to Check Multiple columns are equal in excel office 365?
published: true
date: 2021-10-22 10:47:53 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/how-to-check-multiple-columns-are-equal-in-excel-office-365/
---

Previously, we have seen the formulas to [sum multiple columns using single criteria](https://geekexcel.com/excel-formulas-to-sum-multiple-columns-using-single-criteria/). Similarly, here we will show the formulas to **check multiple columns are equal in Excel Office 365**. Let’s learn the new formula given 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

- To check multiple columns are equal, you have to use the below **formula**.

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

```

## Syntax Explanation

- **AND ** – It is used to check more than  **one logical condition**  at the same time
- **Range ** – It represents the  **input ranges**.
- **Value**  – This is the value that you want to check on the  **given range**.
- **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.

## Example1

- Firstly, you need to **create a sample input values** in Excel.

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

- Then, you have to  **find ** out the **[multiple columns](https://geekexcel.com/insert-multiple-columns-using-macros-vba-in-excel-office-365/) that are equal**.
- Now, you need to ** apply the below-given formula** in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** to get the result.

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

```

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

- Finally, you have to hit  **Ctrl+Shift+Enter**  key to get the  **result ** in **cell H5** as shown below.

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

## Example2

- Firstly, you need to **create a sample input values** in Excel.

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

- Then, you have to  **find ** out the **[multiple columns](https://geekexcel.com/insert-multiple-columns-using-macros-vba-in-excel-office-365/) that are equal**.
- Now, you need to ** apply the below-given formula**  in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** to get the result.

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

```

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

- Finally, you have to hit  **Ctrl+Shift+Enter**  key to get the  **result ** in **cell H5** as shown below.

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

## Closure

In this post, you can get some clarification about the formulas ** to check multiple columns are equal in Excel Office 365**. If you have any other  **ideas**  or  **question,**  do share with us here in the  **comment’s**  section below. Thank you so much for Reading!! For more updates, check out our website **[Geek Excel](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Keep Reading:**

- **[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 Find IF Cells Equal to a Certain Value!! ](https://geekexcel.com/excel-formulas-to-find-if-cells-equal-to/)**
- **[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/)**
- **[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/)**