Phew! Good to hear. No problem

--
Regards,
Dave


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

Got it! Works like a charm. Many Thanks.

"David Billigmeier" wrote:

Whenever you select a range of cells there is always an "active" cell, it's
the one that is white colored (the rest are a grey color). If K1 isn't the
active cell and you reference it in the formula, Excel will point to the
wrong location...

For example, say K3 is the active cell and you enter
=AND(K1<"Brown",K1<"Duffy"). You will only get an error iff you first set
K1 equal to Brown or Duffy and then make a change to K3 (and ONLY in that
exact sequence... complicated, I know)

Can you try it again making sure K1 is the active cell in your range?

I don't know of any reason this shouldn't work in Excel 2000, however I'm
not entirely sure, I use 2003.
--
Regards,
Dave


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

I am not getting any data entry error message at all when using the formulas
below and entering the "bad" names. One question to help me understand:what
do you mean make sure K1 is the active cell? I want the validation to apply
to the entire column.
P.S. I did not mention that I am using excel 2000, if that matters.

"David Billigmeier" wrote:

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