Multiple Validations in for 1 cell
 

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

Multiple Validations in for 1 cell
 

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"
wrote in message
...

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