Data>filter>advanced filer, copy to another location and unique records only
--
Regards,
Peo Sjoblom
(No private emails please)
"JohnGuts" <[email protected]> wrote in message
news:[email protected]...
> 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
Bookmarks