Forum Discussion

BeWu's avatar
BeWu
Frequent Visitor
5 years ago
Solved

FILTER problems

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. 

 

Need Help
  • tex628's avatar
    tex628
    5 years ago

    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

2 Replies

  • tex628's avatar
    tex628
    Community Champion
    5 years ago

    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's avatar
      BeWu
      Frequent Visitor
      5 years ago

      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