View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default data validation in Execl 2007

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