Take a look at Chip Peason's site:
http://www.cpearson.com/excel/NoDupEntry.htm

Mohamed wrote:

Hi,
I was wondering how to prevent duplicate data using data validation.
Thanks

--

Dave Peterson