Michael has attended:
Excel Advanced course
Duplicate entries
How can I delete duplicate entries in Excel. For example, when several rows contain exactly the same information, how do I get Excel to pick that up and automatically delete them?
RE: Duplicate entries
Hi Michael
Thanks for the post
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.
To Remove this go to the Data menu, point to Filter, and then click Show All. The original list is re-displayed.
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
