One small flaw in Excel is the inability to automatically recognize duplicate records. To erase these duplicate records, some friends are a manual deletion, both time-consuming and laborious.
Although Excel does not provide us with the ability to erase duplicate records, we can also use its advanced filtering capabilities to achieve the same goal. Today, I'm going to show you how to use Excel's "Advanced filter" to subtly remove duplicate records.
(Note: The techniques described in this article have been tested in Microsoft Excel 2003 environment.)
The specific steps are as follows:
1. Open a copy of the Excel document with duplicate records. As shown in Figure 1 (note: This image has been processed with Photoshop, where the color portion is a duplicate record)
Figure 1
2. Select All records in the chart (note that the header row for each column should also be selected, otherwise the header row will no longer be included in the filtered datasheet), and perform the data menu → filter → advanced filter Command
3. In the Advanced Filter dialog box that pops up, select Copy filter results to another location. and click on the "Copy to" the range button behind the selection box to select an area to store the filtered data (note: Do not overlap with the original data in the cell, otherwise the data table will be confusing), and finally, check " Select the Not duplicate record check box, and then click the OK button. As shown in Figure 2
Figure 2
4. At this point, Excel automatically deletes all duplicate records, and when you are sure, you can copy the newly generated list to the new worksheet for continued use. As shown in Figure 3
Computer Tutorials Figure 3
How, is not very convenient, then quickly move your mouse to try it!