View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How do I get data validation to disallow specific entries

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

DV won't accept array constants.

List the words in a range. Name the range List.

=AND(A1<List)

Biff

"Harlan Grove" wrote in message
ups.com...
David Billigmeier wrote...
...
=NOT(OR(A1="text1",A1="text2"))

...

Shorter and more easily extensible as

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