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