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