Compare Two Columns in Excel Using the IF Condition
You can also use the IF condition to compare two columns in Excel. The Formula that can be used is =IF(A2=B2,”MATCH”,” “). It will return the result as MATCH against the rows that contain, matching values, and the remaining rows will show Not Match.
Compare Two Columns in Excel Using the EXACT() Function
The EXACT() Function is used to compare two text strings and returns TRUE if they are the same and FALSE if they are not the same. EXACT is case-sensitive but it ignores formatting differences.
Syntax: =EXACT(text1,text2)
It takes two arguments text1, and text2.
Let’s consider the below Example. There are two columns Cities1 and Cities2. The formula =IF(EXACT(A2,B2),”Match”,”Not match”)
The EXACT() returns values as True or False. The execution of the formula would be: First, the inner function would be executed, and the result returned.
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