Multiple Validations in for 1 cell

[dmcnutt_ghg]

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

 

[Bob Phillips]

Use a DV formula of

=AND(COUNTIF($A$3:$A$1000,A15)=1,LEN(A15)<=10)

no need for VBA

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dmcnutt_ghg" <[email protected]>
wrote in message
news:[email protected]...