You have a suggestion at your other post in .excel

magix wrote:

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

Name: sample.xls
sample.xls Type: Microsoft Excel Worksheet (application/vnd.ms-excel)
Encoding: x-uuencode

--

Dave Peterson