Remove duplicates in your worksheets

This is one of the most used commands xlCompare does this work in a seconds. All you need is to open workbooks you want to merge and select Remove Duplicates command:

When you select Remove Duplicates command, xlCompare does the following:

  • Find unique and duplicate records on both worksheets
  • Duplicate records are removed from the both worksheets

Like the Merge command, this one does all work itself and gives you result in single click.

This command doesn't add color formatting, it just gives you list of records.

On image below you can see typical results on the merge command:

  • Button Compare was changes to Remove Duplicates
  • Only unique records are present on all processed worksheets

See Also:

Merge data from 2 worksheets

Get duplicate records from 2 lists

Bulk Merge operations - merge your data in single click

Undo result of the Bulk Merge operation