Unique Data Validation

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>