How2 filter on a specific criteria

[Darren_CS]

Excel 2003

Columns A and B would have, for example:

A B C
App1 London AMERICA
App1 London EMEA
App1 London APAC
App2 London AMERICA
App2 London APAC
App3 NY AMERICA


I want a list of all B=London Apps where C != EMEA, *BUT* where there is a
London/EMEA combination.

It's that last "but" that's causing me problems.

So my result set would be (because App1 has a London / EMEA row):
A B C
App1 London AMERICA
App1 London APAC


Thanks

 

[Luke M]

After filtering for App1 and London, Custom filter on column C:
Does not equal....."EMEA"