Forum Discussion
Solved
Word Search Slicer?
Say I have a chart like so: ID Description 888 This is BLUE 150 This is dark BLUE 850 This is light GREEN 422 This is RED 397 This is really BLUE 431 This tends to be ...
Ok well her is one example of the way you can solve it.
1. create a table with all your keywords
2 cross join that table to your table you want to search
3 create an if statement that returns the colour value of the description if it contains a keyword
4 remove all other rows.
see example attached.
Ok well her is one example of the way you can solve it.
1. create a table with all your keywords
2 cross join that table to your table you want to search
3 create an if statement that returns the colour value of the description if it contains a keyword
4 remove all other rows.
see example attached.
Thank you! This worked out great.