Formula/function that checks for a set of values.
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
|