Not allowing duplicates to be entered in a column

[blstamps]

I am trying to ensure that users entering data into an Excel workshee
only enter unique values in a particular column (values provide
earlier in the column cannot be duplicated). Does anyone know a
effective way to approach this requirement

 

[JE McGimpsey]

One way:

http://cpearson.com/excel/nodupentry.htm