Removing Duplicates from a List

Contact Us or call 1-877-932-8228
Removing Duplicates from a List

Removing Duplicates from a List

Excel makes it easy to remove duplicates from a list, which can be really helpful when working with long lists. To remove duplicates from a list:

  1. Select a cell within the list that you wish to remove duplicates from.
  2. On the DATA tab, in the Data Tools group, click the Remove Duplicates command:
  3. In the Remove Duplicates dialog box:
    1. Depending on whether your list has headers, check or uncheck My data has headers.
    2. Check those columns that contain duplicates you wish to remove.
    3. Click OK.
  4. Click OK in the dialog box that appears telling you how many values were found and removed, and how many values remain.
Next