Data Validation (comma separated cells)

Hi,

I don't believe it's possible using standard data filtering which uses the complete text of a cell for the basis of its filtering. You could use the Text filter with the 'Contains' option and enter text but I guess that's not quite what you have in mind.

No doubt a macro could be written to create a criteria range from the constituent parts of a selection and then drive a Data Filter Advanced, but that seems a bit clunky and messy.

But tell me why you need to have the drop down values combined in the way you do. It's quite an unusual way of using the validation functionality, and as you know it needs a macro to do it?

What's the overall end goal here. There may be a simpler way of achieving it if we can understand your whole process rather than what appears to be a subset.