Duplicates
 

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

Duplicates
 

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.

Duplicates
 

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.


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

Duplicates
 

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.

Duplicates
 

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.

Duplicates
 

Daniel:

Tks I will try it

Damon



"Daniel CHEN" wrote:

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.


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