How To Find Match Between Two Columns In Excel
Display Duplicates | Unique Values in Each Cavalcade | Row by Row Comparing
To compare two columns, use IF, ISERROR and Match in Excel. You can brandish the duplicates or the unique values.
Before nosotros showtime: practice you want to compare 2 columns by highlighting the unique values in each column? Visit our page about comparing ii lists.
Display Duplicates
Let's start by comparing two columns and displaying the duplicates.
one. Display the duplicates in the offset cavalcade (these values too occur in the second column).
Explanation: the MATCH function in cell C1 returns the number 5 (letter of the alphabet A establish at position 5 in the range B1:B7). As a event, the ISERROR role returns Simulated and the IF role returns the value in jail cell A1. The MATCH office in jail cell C4 returns a #N/A mistake (no letter D in the range B1:B7). As a effect, the ISERROR office returns TRUE and the IF office returns an empty string.
2. You can also display the duplicates in the second column.
Annotation: at pace 1, nosotros matched each value in the commencement cavalcade with the range in the 2nd cavalcade. At step 2, we match each value in the second cavalcade with the range in the beginning cavalcade.
Unique Values in Each Cavalcade
Do yous want to compare 2 columns by displaying the unique values in each column? Only swap the final ii arguments of the IF function.
1. Display the unique values in the kickoff cavalcade (these values do not occur in the second column).
Notation: take a look at the second picture on this page to see that nosotros swapped the last 2 arguments of the IF role.
two. Yous can likewise display the unique values in the 2nd cavalcade.
Note: take a await at the third flick on this page to run into that we swapped the last 2 arguments of the IF part.
Row past Row Comparison
For a quick row by row comparison, simply employ the IF function in Excel.
one. The IF function in prison cell C1 below returns Lucifer considering the value in cell A1 is equal to the value in cell B1.
two. To perform a case-sensitive comparing, add together the EXACT function.
iii. Do you desire to compare 2 columns past highlighting the differences in each row? Visit our page about Row Differences.
Source: https://www.excel-easy.com/examples/compare-two-columns.html
Posted by: brownthorthamme.blogspot.com
0 Response to "How To Find Match Between Two Columns In Excel"
Post a Comment