As T. Valko said you CANNOT use array functions in data validation

That's not what I said at all! <bg

DV won't accept array constants.

DV will accept array formulas but not array constants. These are not the
same!

An array constant can be identified by the squiggly braces around an array
of values used as an argument to a function:

=AND(K:K<{"Brown";"Duffy"})

This is an example of an array formula:

=AND(A1<List)

If an array formula is entered in a *worksheet cell* it must be entered with
the key combination of CTRL,SHIFT,ENTER (not just ENTER). Excel will enclose
the formula in the same squiggly braces but this is not an array constant:

{=AND(A1<List)}

Now, when you use an array formula in a refedit (Data Validation,
Conditional Formatting, InsertNameDefine, etc) the formula is
automatically evaluated as an array and doesn't need to be entered with the
array key combination. In fact, using the key combo will have no effect.

Biff

"David Billigmeier" wrote in message
...
Yes, As T. Valko said you CANNOT use array functions in data validation,
so
Harlan's post will not work. My original post will work, I'll update to
correspond to your range and values:

Highlight the entire column K and enter either of the following (make sure
K1 is the active cell):
=NOT(OR(K1="Brown",K1="Duffy"))
=AND(K1<"Brown",K1<"Duffy")

--
Regards,
Dave


"a-one-and-a-two" wrote:

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