Aladin,
Shouldn't H22 be "N"?
[see Greg's exhibit]
...
What if the OP has a "ZE" or "SB" in E20.... would he/she want an "N"..... judging by the original post...not necessarily....hence my version above.
-NBVC
What if the OP has a "ZE" or "SB" in E20.... would he/she want an "N"..... judging by the original post...not necessarily....hence my version above.
-NBVC
Yeah, not so fast fancypants, I hadn't gotten to you yet... you overdid it, actually , per the OP, we didn't need to wildcard the PBX test, i.e.<ul>[*]=IF(OR("PBX"=E20,ISNUMBER(FIND({"SB","ZE"},F20))),"N","Y")[/list] would have worked.
NBVC, while I like yours (though I would have used SEARCH, not FIND due to FIND's case sensitivity); I have to give the nod to our guru on this one since it can be more easily adapted to avoid yielding false positives on column F values like "ZZE30" or "ASB40" i.e. <ul>[*]=IF(SUM(COUNTIF(E20:F20,{"PBX","SB*","ZE*"})),"N","Y")[/list]
...whenever I come up with something I think is robust, one of you guys (rightfully) shows a better more robust way of doing it , and I feel like a rube again I'll keep trying, though :wink:
-hatman