Work fine many thanks

"David McRitchie" wrote:

see
Excel -- Data Validation -- Custom Validation Criteria Examples
http://www.contextures.com/xlDataVal07.html

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"pcor" wrote in message ...
I want to restrict duplicates names in Col B.I forgot how to do that using
data validation. Can someone help.Thanks