How2 filter on a specific criteria

  • Thread starter Thread starter Darren_CS
  • Start date Start date
D

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
 
After filtering for App1 and London, Custom filter on column C:
Does not equal....."EMEA"
 
Back
Top