Hi

check out
http://www.cpearson.com/excel/NoDupEntry.htm

for full details on how to do this.

Cheers
JulieD

"Mohamed" wrote in message
...
Hi, How can i prevent duplicate of data in a coloumn using data validation