Hi,

say your area is A1 to C20. Select it go to Data Validation and enter.

=COUNTIF($A$1:$C$20,A1)=1

VBA Noob