The Compare Tables add-in compares two Excel lists for duplicate and unique rows.
Duplicate rows are the rows that are present in both the first and the second table. Unique rows are the rows that are present in table 1 but are missing in table 2. The add-in searches for duplicates and uniques by the key columns you select. The dupes and uniques are identified only in table 1.
Please make sure both tables are opened in Excel. They can be in different files but the add-in will compare them as long as they are open in the same instance of Excel.
We strongly recommend keeping the checkbox Create a backup copy of the worksheet selected, as Excel won't let you undo the changes made by the add-in.
On the Ablebits Data tab, in the Merge group, click Compare > Compare Tables:
Once you start the add-in, you will see the step you are on at the top of the window.
First, select the range with your table 1: all changes will be applied to the table you select on this step.
If you select just one cell in the table, the add-in will automatically highlight the used range at the start. You can change the range by editing it manually in the Select your first table field, using the Select range icon there, or simply by choosing the right cells in Excel.
On this step, you can see all open workbooks and worksheets in the Select your second table field. Choose the second Excel worksheet to check for the same values there:
Click any cell in a table, and get the entire used range selected automatically. If you need to use only a specific range for comparison, click the Select range icon and highlight the necessary cells.
When the second table is chosen, click Next.
Specify whether you are going to search for duplicate or unique values: :
This step displays a list of columns in both Excel spreadsheets.
Select the column(s) from the first table and the matching column(s) from the second worksheet to compare them and check for duplicate or unique data.
Once the columns are chosen, click the Next button.
Finally, you can choose what to do with the found duplicate or unique rows:
Then enter the name of your scenario and click OK.
Click Finish and voila! The dupes or uniques are found in your table 1 and processed the way you need.