How2 filter on a specific criteria
 

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

How2 filter on a specific criteria
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"Darren_CS" wrote:

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