MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by My on January 03, 2002 10:46 AM

I would a fomula where if in this range abc appears then return 1 else conitue search.

Please help

Posted by Aladin Akyurek on January 03, 2002 11:00 AM

My --

I think you're looking for:

=IF(COUNTIF(A2:A100,"abc"),1,0) or


where B2 houses the search string.

If you want to count "XabcZ" also as a positive result, use:




Posted by Dan on January 03, 2002 11:05 AM

Your sentence isn't complete. What are you trying to do?