On Jun 17, 9:20*am, "Bob Phillips" wrote:
=AND(OR(AND(J10=1,J10<999999),J10="CC1",J10="CC2" ,J10="CC3",J10="CC4"),
COUNTIF($J10:$J22,J10)=1,MOD(J10,111111)<0)

--
__________________________________
HTH

Bob

"Seanie" wrote in message

...



I have the Data Validation detailed below, it does a couple of things
for me, but how can I add an additional validation that will disallow
the input of the same 6 numbers eg a user that inputs 666666 or 111111
or 555555 etc?

=AND(OR(AND
(J10=1,J10<999999),J10="CC1",J10="CC2",J10="CC3", J10="CC4"),COUNTIF
($J10:$J22,J10)=1)- Hide quoted text -

- Show quoted text -

I've used the formula from Bob, only thing I'm finding is that it will
not accept an input value of CC1 or CC2 or CC3 or CC4

It does, however as I wanted disallow, 6 numbers of the same being
input