Advance filter multiple not query

Hi
On the attached I have a database on cities which each have upto 3 capacity configurations, using advance filter I can filter just those cities which contain capacities using the criteria in the filter. I want to go one step further on the third tab with the criteria show me the cities which contain capacities between 200 - 700 but also NOT in the list of locations provided - is this possible and how would i lay it out in advance filter

Any help greatly appreciated

Dave

Hi, faodavid!

You can use advanced filter with boolean formula:
=AND(OR(AND($B2>=200,$B2<=700),AND($C2>=200,$C2<=700),AND($D2>=200,$D2<=700)),ISERROR(MATCH($A2,$F$2:$F$55,)))

Check the file with advanced filter applied. Blessings!