Hi!

Here's a way to do this dynamically....

Create a dynamic named range for the zip codes in column A.

Assume the codes are in the range A1:An

Cell B1 must be empty.

To extract the unique codes in B2 on down, enter this formula using the key
combo of CTRL,SHIF,ENTER:

=IF(ISERROR(INDEX(rng,MATCH(0,INDEX(COUNTIF(B$1:B1 ,rng),,1),0))),"",INDEX(rng,MATCH(0,INDEX(COUNTIF( B$1:B1,rng),,1),0)))

Copy down to enough cells so that when you enter new unique codes they will
be "picked up" by the formula in column B.

Rng is the dynamic named range for the codes in column A.

All of this is contingent on the fact that there will be no empty cells
within the range of codes in column A.

Want to see a sample file with this implemented? Let me know how to contact
you.

Biff

"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