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