Hi,
I would like to filter a column whose rows include multiple values separated by dashes. Say:
Column 1
a/b/c
b/d/c
a/f/g
Now I want to filter out the rows which include "a" (in the above example 1st and last row).
Thanks.
Hi,
I would like to filter a column whose rows include multiple values separated by dashes. Say:
Column 1
a/b/c
b/d/c
a/f/g
Now I want to filter out the rows which include "a" (in the above example 1st and last row).
Thanks.
Use three helper columns splitting out the data into THREE columns, since the split does matter to you.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Create a filter and click on the dropdown menu and then go to "Text Filters" and then "Does not contain" and type in the letter you want to filter out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks