Duplicates

[Guest]

Is there a way that I could prevent DUPLICATES in a column in XL? Similar to
a “Key†in Access.

 

[STEVE BELL]

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
???

 

[Daniel CHEN]

Use menu data > validations
select "Custom" from [allow]
and type "=COUNTIF($A$1:$A$1500,A1)=1" in [Formula]

Assume your input will be in column A range A1:A1500.

 

[Guest]

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]

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.

 

[Guest]

Daniel:

Tks I will try it

Damon

Use menu data > validations
select "Custom" from [allow]
and type "=COUNTIF($A$1:$A$1500,A1)=1" in [Formula]

Assume your input will be in column A range A1:A1500.

Is there a way that I could prevent DUPLICATES in a column in XL? Similar
to
a "Key" in Access.