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 exam...
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

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
    4 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