MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula


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

=IF(COUNTIF(A2:A100,B2),1,0)

where B2 houses the search string.

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

=IF(COUNTIF(A2:A100,"*"&B2&"*"),1,0)

Aladin

=========

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

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