FILTER problems

[BeWu]

Hi,

I have a column (text) : is it possible to filter this column using eg: SEARCH, FIND method or different. I don't want to split this column into other columns. I would like to filter for example all rows that a=YES and b,c,d=NO. I have tried RIGHT and LEFT function but using this method I could anly filter a and d.  I also have tried FIND and SEARCH but without any success. Thanks for your help in advance. 

[tex628 · Accepted solution]

Hi @BeWu ,

I don't know if I'm missunderstanding you or not but can't you simply add a slicer with your current column and select the "a:YES b:NO c:NO d:NO" value to get the selection that you're aiming for? 

If you want to select a/b/c/d individually you are going to have to split them into different columns. 

Br, 
J

[BeWu]

Hi tex628,

Thanks for your answer. I have also found that this problem can be resolved using FILTER and 

CONTAINSSTRINGEXACT functions as well. 

Kind regards. 

BeWu