excelmania370
New Member
- Joined
- Mar 22, 2016
- Messages
- 7
Hi All,
I'm trying to work out how many unique customers bought a particular product. Example Below
<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
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