Knowledge Point Analysis:
When there are duplicate data in the Excle table, if the data is not much can be judged by the naked eye, and if the data record is hundreds or even tens of thousands of times to see through the eyes will become very unreliable. How to quickly find duplicate records in a worksheet and delete them, you can take advantage of delete duplicates in Excel 2010.
Operation Steps:
1. There are 330 records in the current worksheet, and some duplicates may be included, as shown in Figure 1:
2, select all the data in the table, and then click the Delete Duplicates button on the Data tab, as shown in Figure 2:
3. In the Delete Duplicates dialog box that opens, you can select one or more columns that contain duplicate values, select them all, and then click OK, as shown in Figure 3:
4. At this point you can see that "6 duplicate values have been found, they have been deleted, 323 unique values have been retained," and click OK to find and delete a duplicate value that is complete, as shown in Figure 4: