preventing worksheet-wide data duplication

[tim]

I have looked at the data validation function to prevent
duplication in a list. How can I adapt this so that any
new value I enter will check all previous entries in the
worksheet and prevent duplicate entries.

thanks . ..

 

[Anon]

I have looked at the data validation function to prevent
duplication in a list. How can I adapt this so that any
new value I enter will check all previous entries in the
worksheet and prevent duplicate entries.

thanks . ..

Take a look here for how to do this:
http://www.contextures.on.ca/xlDataVal03.html
Whilst there, have a good look around. You won't find better on data
validation.

 

[Ken Wright]

Just another link to similar info - Site is also well worth a trawl when you have a spare year or
two.

http://cpearson.com/excel/NoDupEntry.htm