How Do I Match Two Columns In Excel And Compare Two Columns In Excel
Display Duplicates | Unique Values in Each Cavalcade | Row by Row Comparison
To compare two columns, use IF, ISERROR and Lucifer in Excel. You lot can brandish the duplicates or the unique values.
Before we commencement: practise you want to compare ii columns by highlighting the unique values in each column? Visit our page virtually comparing two lists.
Display Duplicates
Let's start past comparing two columns and displaying the duplicates.
1. Brandish the duplicates in the beginning column (these values as well occur in the second column).
Explanation: the MATCH function in prison cell C1 returns the number 5 (alphabetic character A found at position 5 in the range B1:B7). Every bit a result, the ISERROR function returns FALSE and the IF function returns the value in cell A1. The Friction match function in cell C4 returns a #N/A mistake (no letter D in the range B1:B7). As a effect, the ISERROR function returns Truthful and the IF function returns an empty cord.
two. You lot can likewise brandish the duplicates in the 2d column.
Notation: at step 1, we matched each value in the showtime cavalcade with the range in the second column. At footstep two, nosotros match each value in the second cavalcade with the range in the starting time cavalcade.
Unique Values in Each Column
Exercise you want to compare 2 columns by displaying the unique values in each column? But swap the concluding 2 arguments of the IF function.
ane. Brandish the unique values in the first column (these values do not occur in the second cavalcade).
Notation: take a look at the second picture on this page to see that we swapped the final two arguments of the IF function.
2. You can also display the unique values in the second column.
Annotation: have a look at the 3rd picture on this folio to run into that we swapped the last 2 arguments of the IF function.
Row past Row Comparison
For a quick row past row comparison, simply use the IF function in Excel.
1. The IF function in cell C1 below returns Match because the value in jail cell A1 is equal to the value in cell B1.
two. To perform a case-sensitive comparison, add the EXACT function.
3. Do yous desire to compare two columns by 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: cooperappermak.blogspot.com
0 Response to "How Do I Match Two Columns In Excel And Compare Two Columns In Excel"
Post a Comment