A duplicate row (also called a record) in a list is one where all values in the row are an exact match of all the values in another row. To delete duplicate rows, you filter a list for unique rows, delete the original list, and then replace it with the filtered list. The original list must have column headers.
Because you are permanently deleting data, it's a good idea to copy the original list to another worksheet or workbook before using the following procedure.
- Select all the rows, including the column headers, in the list you want to filter.
Tip
- On the Data menu, point to Filter, and then click Advanced Filter.
- In the Advanced Filter dialog box, click Filter the list, in place.
- Select the Unique records only check box, and then click OK.
The filtered list is displayed and the duplicate rows are hidden.
- On the Edit menu, click Office Clipboard.
The Clipboard task pane is displayed.
- Make sure the filtered list is still selected, and then click Copy
.
The filtered list is highlighted with bounding outlines and the selection appears as an item at the top of the Clipboard.
- On the Data menu, point to Filter, and then click Show All.
The original list is re-displayed.
- Press the DELETE key.
The original list is deleted.
- In the Clipboard, click on the filtered list item.
The filtered list appears in the same location as the original list.
0 Ads:
Post a Comment