Duplicate

[David]

is there any way to restrict data entry in a cell
to "unique values" only

 

[EZ Money]

Select A1:A10 and Data>Validation>Allw>Custom and enter:
=COUNTIF($A$1:$A$10,A1)=1
and you'll see how it works.