Compare Two Columns in Excel Using Equals Operator
In this method, we will create one more column in our existing dataset as Result which will be used for storing the matched and unmatched responses.
Step 1: Add an Excel New Column
In this step, we will add a new column as “Result” for adding the response as TRUE or FALSE.
Fig 8 – Add Result Column
Step 2: Adding Comparison Formula
In this step, we will add a formula in our Result column to compare whether the two columns contain equal data or not.
=A2=B2(We are using A2 and B2 cells for comparison, you need to change according to your own cells).
Fig 9 – Adding rules for true or false
After using formula in one row, we need to fill the same formula for all the rows. To use the same formula in all rows, Select the bottom right corner of the cell(Here, C2) and pull it down to the cell. Excel will fill the same formula in all the rows.
Fig 10 – Fill formula in all rows
Step 3: Output
Once we have our comparison formula filled in all the rows, excel will automatically fill TRUE for matched and FALSE for unmatched entities.
Fig 11 – Output
How to Compare Two Columns in Excel : Easy and Quick Methods
Excel provides various functions and methods by which we can compare two columns and identify matching and mismatching data. Working with a very large Excel dataset, comparing two different columns, and recording the result as Matched or Not Matched can be very time-consuming. It is simple to compare columns in small tables but it becomes complicated when you need to compare two columns in a large spreadsheet. Comparing the columns manually is a time-consuming approach that can be avoided with the application of some fundamental knowledge of Excel.
Contact Us