Thanks Steve, really appreciate you taking the time to answer.
Won't your suggestion only show the products selected in you filter though?
Let's say I've got 26 products A through to Z.
I want to know those customers that bought product B bought what else?
So in Excel I'm going to have Rows of Customers, Columns of Products.
I only want Customers who have bought B without losing the other products in the different columns.
Or do I misunderstand how you're using Excel (I'm thinking Pivot Table)
Regards
Giles