Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicates
Is there a way that I could prevent DUPLICATES in a column in XL? Similar to
a Key in Access. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do not allow duplicates | Excel Discussion (Misc queries) | |||
Duplicates | Excel Worksheet Functions | |||
Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
Help with Duplicates | Excel Worksheet Functions |