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?
