Having a little trouble here...Am I using incorrect syntax? I am validating
column K in my worksheet, so I highlight the entire column, then for my
formula I am typing =AND(K:K<{"Brown";"Duffy"}), where Brown & Duffy are two
of the words I don't want to allow as entries.
I keep getting error that says "you may not use unions, intersections, or
arrray constants for data validation criteria" (!!!!!)
thanks.

"Harlan Grove" wrote:

David Billigmeier wrote...
....
=NOT(OR(A1="text1",A1="text2"))
....

Shorter and more easily extensible as

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