![]() If that's not the case (i.e., some searched cells don't contain the strings being searched for), the formula would need to be modified as follows: ![]() The above formula assumes that every cell being searched will contain either String1, String2, or String3. ![]() Obviously,the syntax is a bit cumbersome, but this will allow you to search for as many strings as you want. Another possibility is nested IF/FIND statements:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |