Hi

Apologies, can't upload from work, so I will do my best to explain what I am trying to do (and hope for the best!)

I have 2 x Columns of data, Column A has account number and Column B has item purchased (there are only 4-5 different items).

I need to summarise this info. So, summarising the items purchased is easy, but I also need to summarise purchases by distinct account. So, for example, look at a product in Column B, we've sold a totol of e.g 700 of them, but I need to know how many unique account numbers have purchased that item, so I might have 700 purchases, but 350 account numbers have bought 2 each. So I'd need my "distinct count" to show 350 there.

I have my list of the 4-5 items available for purchase in a table in a different sheet tab.

Does that make sense?

Thanks