Formula/function that checks for a set of values.
Hi
The formula I reposted (and I've got in my thread and sent items also) is
=AND(B$4:B$21<"E",B$4:B$21<"D",B$4:B$21<"N")
which is different but I don't know why that didn't appear to you!!
Try it.
Andy.
"Memnok" wrote in message
...
Hi
That's because I left the signs out of it!!
Try this:
=AND(B$4:B$21"E",B$4:B$21"D",B$4:B$21"N")
Sorry!
Andy.
Isn't that the same? Ha-ha! :) I copied and pasted them side my side
and they are identical.
You are a trooper, thanks for your continued effort!
--
Memnok
|