One of the essential tasks when cleaning up a data set is getting rid of duplicate values. In this article, we're going to show you  how to remove duplicates in Excel using the Remove Duplicates feature. To find duplicate values using a formula please see:

How to highlight duplicate values in a data set dynamically

How to find the unique items in a list

 

Steps

  1. Select your data or click a cell in that table.
    How to remove duplicates in Excel
  2. Click the Remove Duplicates icon under the DATA tab.
    How to remove duplicates in Excel
  3. Excel can typically identify headers in your data. However, it's always a good idea to enable the My data has headers checkbox, and select the columns you want to remove duplicates from.
    How to remove duplicates in Excel
  4. Click OK to remove the duplicate values in your selection.
    How to remove duplicates in Excel
  5. You will receive a confirmation message with the details on how many cells were affected.
    How to remove duplicates in Excel