Thread: How do I get data validation to disallow specific entries
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default How do I get data validation to disallow specific entries
David Billigmeier wrote...
....
=NOT(OR(A1="text1",A1="text2"))
....

Shorter and more easily extensible as

=AND(A1<{"text1";"text2";...})

Reply With QuoteReply With Quote