Removing Duplicates from a List - Exercise

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

Removing Duplicates from a List

Duration: 5 to 10 minutes.

In this exercise, you will practice removing the duplicates from a list.

  1. Open Remove Duplicates.xlsx from your Excel2013.2/Exercises folder.
  2. The list in this worksheet shows all sales by customer. You would like to see a list showing each customer just once. Use the Remove Duplicates command to create this list.


  1. Select any cell within the list.
  2. On the DATA tab, in the Data Tools group, click the Remove Duplicates command:
  3. In the Remove Duplicates dialog box:
    1. Verify that My data has headers is checked.
    2. Under Columns, make sure Customer is checked and Sale is not checked.
    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: