Filter list in place using one criteria in either of two columns

[DRSteele]

Hello,
I'm attempting to filter a table in place using one search criteria in two columns. Column A lists the DepartureCity and column B lists the DestinationCity; there are many rows and other columns too. What I want to do is filter the list in place so that I can choose, say, London, and I will see the records that contain London in either the DepartureCity column or in the DestinationCity column. I would prefer not to use a helper column (which, I am aware, would do the trick).

Can someone please help me?

 

[ParamRay]

Advanced filter!

Tutorial:
Advanced Filter in Excel - Easy Excel Tutorial

 

[DRSteele]

Thanks for your response, GPeakcock.

That did work.