I am trying to identify the unique customers that have purchased a product. I have tried multiple formulas (see below) however I cannot get any of them to work correctly with multiple criteria. Below is my data set:
Data Set
Item Customer
a 8089
a 8089
b 8089
c 8089
d 8089
a 8089
a 8089
a 8089
a 9337
a 13514
b 13514
a 26048
a 26992
a 29684
c 29684
a 29984
a 30926
The resulting answers should be:
Item Distinct Customers
a 8
b 2
c 2
d 1
The challenge is applying this to a very large data set (100k+ lines) and I hate "breaking excel" as I do far to often by not using streamlined formulas.
Bookmarks