Take out duplicates

Hi Michelle

Thanks for the post - sorry for the late reply

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.

this should do the trick Merry Christmas

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn