Excel filter Multiple Value With Drop Down

Hi everyone, my first post here. I am looking for help on filtering multiple values in one cell delimited by a comma. For example I have a spreadsheet with the following data:
Untitled.png

When I filter on the 'Characteristics 1' I see checkboxes for the following:
Untitled1.png

But I hope it has dropdown
Untitled2.png

So I can filter out based on each element

Please note that the above is just an example and I have multiple individual requirements, so it would not be as simple as having one column per requirement.

You could use a filter too.

Formula:

Please Login or Register  to view this content.

Thank you so much for your solution. Because users who use this spreadsheet don't have a deep understanding of excel. Do you know how to create a cutomize multiselect filter ?

Thank you for the help! In your spreadsheet, we are able to select one element from the drop-down. How can turn it muitiselect filter for this?

You mean like that?

Formula:

Please Login or Register  to view this content.

I hope I can create something like an auto filter with a checkbox in front of each selection. So I can choose what I want all together

Thank you so much!!! Your formula helps me alotttt!