Find duplicates and unique rows in two sheets in Excel
One of the most popular searches in Google: How to compare two Excel sheets for matches. Or how to get unique rows between two Excel worksheets.
In this tutorial we explain several methods on how to compare two Excel sheets and find duplicate rows.
This task is relatively simple, and you should not be an Expert in Microsoft Excel to find duplicate rows between two Excel sheets.
Use xlCompare tool to find matching rows between two sheets
Compare two Excel sheets with xlCompare
Look into the following tutorial. You need to take just a few steps to the results.
Start xlCompare application
Usually, xlCompare shortcut is present on your desktop. So, you can start it from your desktop.
Drop your Excel file into xlCompare
The simplest method to open a file in xlCompare is to drop the file from Windows Explorer right into xlCompare.
So, just drop your file into the Left Panel in xlCompare and into the Right Panel in xlCompare.
Now you have Sheet1 on the left and Sheet2 on the right.
Compare Excel Sheets
Click the Compare sheets button on the Compare tab on the ribbon.
xlCompare immediately gives you comparison results.
Unique rows on both worksheets are highlighted with fill color. xlCompare uses red color on the right sheet and green color on the left sheet.
Also, xlCompare compares values in all matching rows. This is a good benefit you are getting.
Filter Matching Rows in two Excel sheets
xlCompare contains several filtering commands on the ribbon, you can use to filter matching and duplicate values on the sheets.
Apply Filter Duplicates command to get only matching rows on your screen.
Save Matching Rows on the other Excel sheet
After you've completed the previous step, use Save | Visible Rows command from the Right Click Menu. It will ask you to select Excel file for the resulting data.
Get rid of unique rows on two sheets in Excel
Use the Filter Unique Rows button on the xlCompare ribbon.
Now you have only unique rows on your screen. They are highlighted with colors.
Select all rows on the worksheet by clicking on the heading and delete them using the Delete command in the right click menu.
Just in a few clicks you've removed all unique rows between two Excel sheets.
See Also
I have a question
Please, describe your question or inquiry in the form below. We will be happy to respond you!