Advanced Filter and data inside a text field

[showgie]

I have a cell of data that contains information like this:

John Smith, Jane Doe, Robert Jones, Kermit TheFrog, Fozzie TheBear

It needs to keep this format (because it will be re-imported from another source over and over, and this is how it arrives.)

I'd like to use the Advanced Filter to find the rows that contain BOTH John and Fozzie. Please tell me there's a simple solution and I'm just missing some syntax!

Thanks in advance.

[martindwilson]

see attached

[showgie]

Yay, that helped!!! Thank you so much. I don't know why I didn't realize I could use the same column more than once, but that made everything work correctly.