Pivot table- Select only items having two different variables

Hello,

Please refer the attached spreadsheet. The title of this post may be confusing. If you could go throught the spreadsheet, i guess you will inderstand better.

I would like to show in a pivot table customers who have ordered two different products together only

Any help will be appreciated



Regards,
Joseph

Thanks Sixth sense for your time. May be I was not clear in my question

I need to pick up only those customers who have ordered products "AB" and CD" together. In this example- Karimbinal Corporate ordered only "CD" and it got seleicted. I need to ignore this because this cutomer did not order "AB"

If a customer has ordered products "AB" and "CD" , then it should get selected.

Please see attached sheet

Thanks Sixth Sense , it worked. I am getting the result thanks heaps. But when I am using this for a maaisve file, it is taking to time to populate the result.

Not being too greedy here, just wondering if there was a quicker result which can be used against a file have 12000 lines

THanks heaps.

THanks Heaps Six Sense. Appreciate your great help.