Cell with multiple comma separated values - slicer (or similar) as unique values? (Excel 2016)

[Kingcal53]

I have a table were the last column can contain multiple comma separated values. See column C in the data table below as an example.


[TABLE="class: cms_table, width: 251"]
<tbody>[TR]
[TD][/TD]
[TD]Column A [/TD]
[TD]Column B [/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Jimi[/TD]
[TD]jimi@email.com[/TD]
[TD]Vocals, Guitar[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Mitch[/TD]
[TD]mitch@email.com[/TD]
[TD]Drums[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Noel[/TD]
[TD]noel@email.com[/TD]
[TD]Vocals, Bass, Guitar[/TD]
[/TR]
</tbody>[/TABLE]


A user would like to filter Column C by unique value e.g. "Guitar", or "Vocals" to return all the rows which have that values. Rather than using an Advanced Filter, is there a way to set up a slicer or use slicer style buttons marked "Guitar" "Drums" "Vocals" "Bass", which when selected would return the rows with those values?

For example:

• If I clicked on the button marked Guitar, it would show rows 1 & 3, but filter out row 2.
• If I clicked on the button marked Drums, it would only show row 2.

Thanks!

 

[Steve_]

Wouldnt it be easier to text to column it out, using the comma delimiter? This would create multiple columns out of that data and allow you to set filters.

 

[Kingcal53]

Yeah, probably. If it was just me using the sheet then that's how I'd do it, however it's will be shared with colleagues who aren't particularly Excel savvy so thought having something simple and visual i.e. pre-set buttons to press to filter, might help them out!