View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Repeatition of the same item

DataValidationCustomized
Formula: =COUNTIF(A:A,A1)=1

HTH
--
AP

"S.G.Pillai" a écrit dans le message de
news: ...
I want to avoid repeatition of the tags in the rows i am entering. ie.. if
i
have entered 98TI-107 once it should notify me if i am trying to enter it
once again.
Thanks