Here is a simple tip to prevent duplicates in lists in excel. It does a similar task to the Primary Key in a database. Granted, is is a little watered down, and will only work if you don't allow blanks within the field (Column)
If anyone needs a way to prevent duplicates, this should help just a little.