Yes!

But we need to know how the duplicates get into the column in the first
place.
Importing
Entering - this one is real easy with a worksheet change event
Formula
Code
???

--
steveB

Remove "AYN" from email to respond
"DamonG" wrote in message
...
Is there a way that I could prevent DUPLICATES in a column in XL? Similar
to
a "Key" in Access.