On the 'Customers by Order' worksheet, use an Excel data tool to remove all records with duplicate 'CustomerID' values from the table. Do not remove any other records.

1. Select a cell in the "CustomerID" column which you want to have checked for duplicates. 2. Select Remove Duplicates from the Data tab. 3. Select the "CustomerID" column which you want to have checked under the Columns options. 4. Click OK.

Manage Tables and Lists

Question

On the 'Customers by Order' worksheet, use an Excel data tool to remove all records with duplicate 'CustomerID' values from the table. Do not remove any other records.

Explanation

Select a cell in the "CustomerID" column which you want to have checked for duplicates.
Select Remove Duplicates from the Data tab.
Select the "CustomerID" column which you want to have checked under the Columns options.
Click OK.

Topics

#remove duplicates#data tool#unique records#table cleanup

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice