Damon,

Refer to Daniel Chen's suggestion.

Using Data Validation is by far the easiest way to go.
And you can set it to give the user a message when the cell is
entered, and another message if they try to add a duplicate...
while preventing a duplicate from being entered.

--
steveB

Remove "AYN" from email to respond
"DamonG" wrote in message
...
Steve:

I am entering them each day - just don't want to enter the same info twice

EG: BAL094123
EG: VIPH123900

So my date could vary!

Tks
Damon

"STEVE BELL" wrote:

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.