preventing worksheet-wide data duplication

  • Thread starter Thread starter tim
  • Start date Start date
T

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 . ..
 
tim said:
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 . ..
Click to expand...

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.
 
Back
Top