Chance, have a look at data, filter, advanced filter, copy to new location
and check unique records only

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Chance" wrote in message
...
I have a column of data containing 6 digit codes in each row. I have many
duplicates. How do I create a new column removing the duplicates found in
the original column?