with refer to this link:
http://support.microsoft.com/default...b;en-us;213185
you can use this formula =COUNTIF(A:A,A1)=1
for data validation to prevent duplicate entry. This is very simple and
easy to understand.