Hey all;
I am trying to search a string of characters in a cell and determine if any of several different combinations of characters I define exist in the string. The character string can vary from 1 to 10 characters and the characters appear in random sequence and location.
I have been using;
IF(ISNUMBER(SEARCH($B$24,F15)),"Yes",IF(ISNUMBER(SEARCH($B$25,F15)),"Yes",IF(ISNUMBER(SEARCH($B$26,F15)),"Yes","No")))
and it only works if the characters I define exist in sequence and next to each other in the string.
I need the formula to identify the presence of the 2 characters regardless of their position or sequence in the string.
Suggestions?
Keih
I am trying to search a string of characters in a cell and determine if any of several different combinations of characters I define exist in the string. The character string can vary from 1 to 10 characters and the characters appear in random sequence and location.
I have been using;
IF(ISNUMBER(SEARCH($B$24,F15)),"Yes",IF(ISNUMBER(SEARCH($B$25,F15)),"Yes",IF(ISNUMBER(SEARCH($B$26,F15)),"Yes","No")))
and it only works if the characters I define exist in sequence and next to each other in the string.
I need the formula to identify the presence of the 2 characters regardless of their position or sequence in the string.
Suggestions?
Keih