IronM
New Member
- Joined
- Jan 20, 2022
- Messages
- 15
- Office Version
- 365
- 2019
- Platform
- Windows
Hi,
I would like to make a slicer filter that will take each word from a cell containing multiple word (divided by comma or whatever) and make a filtering based on only one unique word. Like a "search by/containing" but with available words appearing in the slicer.
For instance:
Cell A2: Ana
Cell A3: Ana, Michael
Cell A4: John
Cell A5: Michael
The slicer filter must have separate buttons to filter just for: Ana, Michael, John. As opposed to now, when I get a filter button equal to each cell.
Thank you!
I would like to make a slicer filter that will take each word from a cell containing multiple word (divided by comma or whatever) and make a filtering based on only one unique word. Like a "search by/containing" but with available words appearing in the slicer.
For instance:
Cell A2: Ana
Cell A3: Ana, Michael
Cell A4: John
Cell A5: Michael
The slicer filter must have separate buttons to filter just for: Ana, Michael, John. As opposed to now, when I get a filter button equal to each cell.
Thank you!