In our day-to-day work, we often encounter Excel tables that contain duplicate records, and it's too hard to find these duplicates in a hand-picked way for a large record of Excel. Is there any good way to make these repeated records "catch" easily and quickly? Today, I introduced to you a simple way to easily achieve this goal.
"Note" The techniques described in this article have been tested in Excel 2003 through
1. Open the Excel file that contains the duplicate record
2. Select All records, click the "Data" menu → "filter → advanced Filter" command
3. Tick the Select No Duplicates check box, and then change the filter to "copy filter results to another location" and set the target area
The "small tip" default "show filter in place" item can also get a record that is not duplicated, but after all, it's just a filter, and Excel just hides the duplicate records and doesn't exactly do what we're trying to accomplish.
4. After clicking "OK", the record appearing in the new position is already screened well. Then, we remove the original record by hand and copy the new record back to the original position.