Hello everybody

In my sheet there is the below macro which allows multiple selections in a Data Validation drop-down list and puts each entry on a new line.

I am having trouble filtering the entries using the Auto filter. For instance if I have Blue and Yellow in a cell, they will be listed in the filter's drop-down menu as BlueRed.

I know that I can choose Text Filters - Custom filter... and search for, for instance "contains" Blue, but that requires a lot more clicking and typing.

Is there a way to filter using the drop-down list?

Thank you very much in advance
Philip

Please Login or Register  to view this content.