Thread: Data validation don't work
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mary Mary is offline
external usenet poster
  
Posts: 190
Default Data validation don't work
Hi,
I am trying to set up column D as unique but everytime that I type the below
formula doesn't work. If I enter the same value twice it takes.
=COUNTIF(D:D,D1)<2

Reply With QuoteReply With Quote