Hi

I would like to do search, and filter and copy the necessary one into new
worksheet
Please see attached excel file (Sample.xls) for sample data

Column A is Customer Number
Column B is Fruits
Column C is City

I want only those Apple from New York with one condition. If the Customer
also has Orange from New York, then the customer will not be selected.

From the sample data, the output in new worksheet will be

333 Apple New York
555 Apple New York
888 Apple New York

Thank you.

Regards,
Magix