Aussiebear
I used the datavalidation method shown in your first reply.
Only i changed it to range
It lokk like this then:

[VBA]=COUNTIF($A$4:$A$41;A4)=1[/VBA]