"Dave Peterson" wrote in message
...
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


In addition, I think my requirements is slightly different. If the same
customer has two or more entries, then I need to check under this customer.
Let say I want only Item A provided there is no Item B
Something like:

IF this customer has Item A in Column X THEN
IF this customer also has Item B in Column Y THEN
Ignore Customer
ELSE
Shortlist Customer
ELSe
Ignore Customer