Thread: Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Validation

What am I doing wrong? Column A I've got =countif(a:a,2)=1 because I don't
want duplicate numbers entered. No matter what is entered even numbers that
aren't duplicates, I still get my warning message and won't allow me to enter
anything. Thanks in advance!!