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";...})
|