Thread: Excel2000: Data validation behaving funny
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets
 
Posts: n/a
Default Excel2000: Data validation behaving funny
Oops!

Thanks!
Arvi Laanemets


<Andy wrote in message ...
Hi Arvi,

Are you using
COUNTIF($E:$E,$E1)<2
or
=COUNTIF($E:$E,$E1)<2

Andy.



Reply With QuoteReply With Quote