Forum Discussion

tomgag's avatar
tomgag
Icon for Resolver I rankResolver I
8 years ago
Solved

Search amd exclude certain strings

Hi, I have the search function but want to exclude certain strings.   Ball= IF (ISBLANK ( SEARCH ( "Messi", Table[Column], 1, BLANK () ) ), 0, 1 )   It gives me 1 or 0 depending if Messi is in...
Need Help
Show and Tell
  • tomgag's avatar
    tomgag
    8 years ago
    Ball = IF (NOT(ISBLANK ( SEARCH ( "Messi", 'Table'[Column], 1, BLANK () ) )) && ISBLANK ( SEARCH ( "Ronaldo", 'Table'[Column], 1, BLANK () ) ) && ISBLANK ( SEARCH ( "Pogba", 'Table'[Column], 1, BLANK () ) ), 1, 0)
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi tomgag,

 

It's glad that you have solved your problem. Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

Best Regargds,

Cherry

tomgag's avatar
tomgag
Icon for Resolver I rankResolver I
8 years ago

None of your solutions worked I am afraid.