Hi Mohamed

See
http://www.cpearson.com/excel/NoDupEntry.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



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