Advance Filter

[betmck]

I have a list items I want to copy the list to another location with unique records only. However the first entry seems not to be taken into consideration. Example:

Original List
man
boy
man
boy
girl
man
girl
baby


Filter List
man
boy
man
girl
baby

If the first item on the list is unique, then It is not a problem, but when it appears another time in the list it appears twice on the filter list.

How do I get the first item to be part of the advance filtered list?

[VBA Noob]

Add a header

http://www.contextures.com/xladvfilter01.html#FilterUR

VBA Noob