Quick Dedupe for Excel lists

Quick Dedupe for Excel is a one-step tool to check your worksheets for the same data. It can remove duplicates, select or shade them with color, identify repeats in a status column, copy or move to another workbook or worksheet.

Excel's Remove Duplicates only deletes duplicates and can do nothing more. The Quick Dedupe tool will also help you promptly get rid of all repeated entries. In addition, it can select or shade dupes with color, identify in a status column, copy or move. No formulas, no conditional formatting rules, no waste of time.

The quickest way to deduplicate in Excel is to use Quick Dedupe. Select your range or just a single cell in your table and the whole table will be selected automatically. Click the Quick Dedupe icon on the Ablebits Data tab, and do the following:

1. Select the key columns you want to check for dupes.
2. In the bottom right corner of the pane, select one of the following actions:
   • Delete duplicates
   • Highlight with color
   • Select duplicates
   • Identify in the status column
   • Copy to a new worksheet
   • Move to a new worksheet
3. If needed, tick the Create a backup copy of the worksheet checkbox to get a copy of your original table.
4. Click OK.

For more detailed instructions click here.

Just select one or more key columns to check for duplicates, and get duplicate rows eliminated, selected, highlighted, or marked in a status column as "Duplicate".

Absolutely yes. If you'd like to have a closer look at the duplicate entries later, just choose to copy the dupes to a new worksheet.