compare two columns in excel for differences

Let’s see a different method to check the same. This is one method using which we could check whether the values under two columns have a match or not. You can validate this by using the Len function as well. But the result is FALSE because we have an extra spacing at the end of cell B5. For Example, see the fifth row where two strings are looking exactly similar, and they should match with each other. There are sometimes extra spaces that allow the text to not match using the equality operator.Note that this criterion for matching does not consider whether the text is in the upper or lower case.Same as with the 4 th output where A4 has value as “Google” and B4 has “Googl”.

This is because, for output in C2, A2 has the value “Sweets”, whereas the value in B2 is “swetes”. You can see some of the cells will match with each other from both of the columns, and some of those will not.

Now, drag the formula across all the working cells and see the output as shown below: If both values don’t match, it will return Boolean output FALSE. If both values match, then it will return Boolean output TRUE. This is a logical formula that checks whether the value present in cell A2 is exactly matching with the value present in cell B2. Step 3: Now, we wanted to check if the value present in A2 is matching with the value present in B2 for that, use =B2 as the next argument. Step 2: Since we wanted to compare the value present in cell A2, use A2 as the first argument under C2 after the equals to sign. You can use your keyboard button for the same. Step 1: In cell C2, start initiating the formula using equals to sign (“=”). To check whether two of the columns are matching or not, we can use the simplest method. You can download this Compare Two Columns for Matches Excel Template here – Compare Two Columns for Matches Excel Template Method #1Ĭonsider data as shown in the screenshot below, which includes different text values.

TEXT and String Functions in Excel (26+).

Lookup Reference Functions in Excel (34+).

Excel Conditional Formatting Based on Another Cell Value.

SUMPRODUCT Function with Multiple Criteria.

Compare Two Columns in Excel for Matches.

Compare two columns in excel for differences