Datafilteradvanced filer, copy to another location and unique records only


--
Regards,

Peo Sjoblom

(No private emails please)


"JohnGuts" wrote in message
...
If I have a list (Column) of zip codes in column A that range from 68116
to
68184, and there are multiple entries for each zip code. I would like
Column
B to look through the list and create a new list that takes out the
duplicate
entries. Any ideas how I can do this? I want to be able to add new zip
codes to the list, and have the new list automatically update. Thanks for
any help. JohnGuts