#### excelmania370

##### New Member

- Joined
- Mar 22, 2016

- Messages
- 7

I'm trying to work out how many unique customers bought a particular product. Example Below

Product | Orders | Unique Buyers of Order | ||

Bouncy Castle | 56 | ? (Formula Required) | ||

Trampoline | 32 | ?
<tbody> </tbody> | ||

Inflatable Pool | 77 | ?
<tbody> </tbody> |

<tbody>

</tbody>

The raw data I have is the product, quantity sold, when it was sold, customer type and the customer ID. I need working out the number of unique purchasers by product by month, which I've been doing so far through a long winded method of putting the data into a Pivot table and then a COUNT of orders each userID had made. But I also need a formula to work out the unique purchasers by Customer Type so e.g. How many unique purchasers from the Automotive Sector, and then Retail Sector etc. etc. ordered the 3 products above (Doesn't have to be by month). As an FYI, if a customer ordered twice in a month, that would be 1 unique purchaser.

Any more info needed I'll be happy to provide.

Thanks in Advance