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.
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.
