One way

http://www.cpearson.com/excel/NoDupEntry.aspx


note that it won't prevent copied and pasted values, just typed entries


--


Regards,


Peo Sjoblom


"Minnu" wrote in message
...
Hi thr,

Can anyone help with this I want to get prompted if some enters duplicate
entry into my excel sheet for a particular column.

Thanks a lot,
Vipanchi