Hello All,
For some reason (maybe because it's Monday), this one has got me stumped.
I have a spreadsheet with invoice history from 1/1/2015-1/31/2016. I am trying to find a way to identify the parts that were purchased by only one customer (doesn't matter if they purchased multiple times within a month/year, just has to be that the part was purchased by only one person).
If you see the example below, I only want to return part # ABC2 because Will is the only customer to purchase the product.
Part # Customer Date
ABC1 Kate 1/15/2015
ABC2 Will 2/15/2015
ABC2 Will 2/15/2015
ABC1 Will 3/15/2015
ABC1 John 3/15/2015
ABC1 Sarah 4/15/2015
ABC2 Will 5/15/2015
The Pivot Table isn't working because if I use the count feature it simply counts the number of times the customer shows up for that part, so I don't have a way of filtering that easily.
I'm not sure if this makes sense, but hopefully someone out there has an idea of what to do!
Thanks.
Bookmarks