The extra column and Ron's filter will not help. For my case, I need to
search those entries under same customer, and do the filtering.

The result will be copy to a new work sheet.

Please help.

"Dave Peterson" wrote in message
...
Did you try the extra column and Ron's easyfilter?

If you did and it failed, post back with your questions.

magix wrote:

"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

To make it simple, let say I have this record:
111 Apple NewYork
111 Banana NewYork
222 Apple NewYork
222 Banana NewYork
222 Orange NewYork
333 Apple NewYork
555 Banana NewYork
555 Orange NewYork
666 Apple NewYork
777 Orange NewYork
777 Apple NewYork

The output I want is:

111 Apple NewYork
333 Apple NewYork
666 Apple NewYork

Note: For Apple in Customer 222 and 777 are NOT selected because this
customer has ORANGE

So, what is the suitable coding to search through multiple rows for same
customer , and do filtering there based on same customer number ?

Thanks.

Regards, Magix

--

Dave Peterson