View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Memnok
 
Posts: n/a
Default 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