In Excel 2010, how can I quickly delete duplicate records? Excel record repetition tutorial

1. As shown in the following figure, we have hundreds of records and there is a useless duplicate item in them. What should I do if I want to delete it, as shown in Figure 1:

2. Select the entire excel table, click the "data" menu, and then click "delete repeated items", as shown in Figure 2:

 

3. in the displayed window, find the "delete repeated items" dialog box. You can select one or more columns with duplicate values. Select all columns and click "OK, figure 3:

4. The number of duplicate records is displayed. Several duplicate records are deleted and 323 unique values are retained. Click OK"

In this way, the record is deleted successfully.