Tue 22 May 2007, 10:00Delegate Mark said...
Mark has attended:
Excel Advanced course
Access Introduction course
Preventing Duplicates In A List
Hi
I know how to extract duplicates from a list but is there any way to prevent them being entered in the first place.
I have a unique list of product codes and if i try to enter a code that already appears in the list, i need to be alerted.
Many thanks
Mark
Thu 24 May 2007, 15:02Trainer Richard said...
RE: Preventing Duplicates In A List
Hi Mark,
You can do this in Access, by making the field a primary key, or by indexing the field in design view. select YES, No duplicates.
In excel I do no think that you can do this as it requires a dynamic list.
regards
Richard
