• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search function

paradise
Syntaxes
=IF(Something is True, then do something, otherwise do something else) =SEARCH(find_text,within_text,[start_num]) =IF(SEARCH(find_text,within_text,[start_num]), then do something, otherwise do something else)
 
=SUMPRODUCT(--ISNUMBER(SEARCH({"Apple","Apes"},AC8)))

will return a zero if not found , a 1 if either apples or apes are found in string - 2 if both are found
only get an error if cell ac8 has an error

a you looking for that sort of result ?
i'm away for a couple of days - and may not get a chance to reply further -
 
Back
Top