I have data validation set up to equal text six characters long. Now, I need
to make sure that all values entered are unique. The characters will always
be six numbers, but must be unique from any other six numbers in the column.

Thanks

Jeff

See http://www.contextures.com/xlDataVal03.html

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"jeffbert" wrote in message
...
I have data validation set up to equal text six characters long. Now, I
need
to make sure that all values entered are unique. The characters will
always
be six numbers, but must be unique from any other six numbers in the
column.

Thanks

Jeff