Find and delete duplicates in Excel table

Check your worksheet for dupes and unique values

Finding and removing duplicates in Excel may be a real headache, especially when your worksheets contain thousands of rows. Duplicate Remover for Excel does the job quickly and perfectly – it can find and delete duplicates based on one or several key columns, identify unique values, highlight, copy or move the found entries.

Learn more
This tool is part of
Ultimate Suite
Duplicate Remover for Excel 2016 - 2007

With Duplicate Remover for Excel you will

  • Search for duplicates Find absolutely all duplicates in your worksheet, including their first occurrences.
  • Find dupes without 1st occurrences Check your table for duplicate records, excluding their first instances.
  • Dedupe by multiple key columns Check your worksheet for duplicate rows by selecting several key columns.
  • Delete duplicates in Excel Eliminate all duplicate cells or repeated rows in one go.
  • Highlight duplicate and unique values Shade repeated and unique values in any color of your choosing.
  • Check for unique values Use this option to find the entries that appear in your spreadsheet only once.
  • Find uniques + 1st occurrences of dupes Identify all different values in your Excel document to get a list of distinct entries.
  • Identify duplicates in a status column Get a new column with "Unique" or "Duplicate" marks added in each row.
  • Show duplicates by selecting them Have unique or duplicate cells selected in your table.
  • Move or copy dupes and uniques Copy unique entries or move dupes to a new Excel file.

How to remove duplicates in Excel

  
Video: how to remove duplicates in Excel
Select the table to search for duplicates
Select the table to search for duplicates
Choose to find duplicate values
Choose to find duplicate values
Select the key columns
Select the key columns
Choose the action
Choose the action
Get all the duplicates highlighted
Get all the duplicates highlighted
Video: how to remove duplicates in Excel
Select the table to search for duplicates
Choose to find duplicate values
Select the key columns
Choose the action
Get all the duplicates highlighted

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Duplicate Remover for Excel

  • What is Duplicate Remover for Excel?

    Duplicate Remover for Excel is designed to find duplicates and unique values in one Excel table. It offers plenty of options to deal with the found entries: delete duplicates, identify dupes and unique values by adding a status column, highlight with any color, select, copy or move the results to another file or worksheet.

  • Can't I remove duplicates using Excel's built-in features?

    The Remove Duplicates tool is available in Excel 2007, Excel 2010, Excel 2013, and Excel 2016. But it can only delete duplicates, leaving unique values and first occurrences of duplicates in a table, and does nothing else.

    Our Duplicate Remover add-in offers a wide range of options. It can search for repeated or unique records with or without 1st occurrences. Apart from removing duplicate values and rows, it can select and highlight them, add a status column, copy or move.

  • How to search for duplicates with or without first occurrences?
    Click the Duplicate Remover icon on the Ablebits Data tab, and perform the following steps:
    1. Select your table or any single cell within it.
    2. Choose what kind of entries you want to find:
      • Duplicates except their first occurrences.
      • All duplicates including the first instances.
    3. Select one or more columns to check for duplicate values.
    4. Choose the desired action, for example Highlight with color.
    5. Click Finish.
    6. The detailed step-by-step instructions can be found here.

  • How to check my worksheet for unique and distinct values?

    To identify only unique entries or all different items in a list, run Duplicate Remover and select one of these options on the second step:

    • Uniques to find only unique values.
    • Uniques + 1st occurrences to find distinct values, i.e. uniques and first instances of repeated values.
  • Is it possible to show duplicates in Excel without removing them?

    Sure. Don't let the name of the add-in trick you, with Duplicate Remover you can get all the duplicate values automatically selected or highlighted without any actual removals.

  • What if I want to find dupes or uniques and copy them to another worksheet?

    No problem. You can do with the found values whatever you want: select or highlight them, identify in the status column, copy or move to another file or worksheet.

  • Is there a faster way to deduplicate my Excel tables?

    Yes, it is. Our Quick Dedupe tool can find and remove duplicates in an Excel table, list or column with a single mouse click.

Supported versions

 

Excel

  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.
Excel add-ins and Outlook tools - Ablebits.com