Insert this formula as one member of your AND function:
=NOT(AND(LEFT(A1)=MID(A1,2,1),LEFT(A1)=MID(A1,3,1) ,LEFT(A1)=MID(A1,4,1),LEFT(A1)=MID(A1,5,1),LEFT(A1 )=MID(A1,6,1)))
Change A1 to the real reference!
Regards,
Stefi

€žSeanie€� ezt Ã*rta:

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)