I am using the validation tool to verfy data entry. I want to make sure
that I am not letting the user enter duplicate data and have entered a
custom validation rule of

=COUNTIF($A$3:$A$1000,A15)=1

I would aslo like to limit the data entry to no more than 10
characters.

How do I make this happen?

I am not a programmer and do not know any vb code.

Debbie


--
dmcnutt_ghg
------------------------------------------------------------------------
dmcnutt_ghg's Profile: http://www.excelforum.com/member.php...o&userid=29044
View this thread: http://www.excelforum.com/showthread...hreadid=487748