Finding unique customer total of data for a year
Posted on 2013-01-31
Ok here is what I have -
Customers who purchased items over a year time span. Each customer may have purchased multiple items per day. The customer may have also purchased the same item multiple times during the year. What I want to know is the number of unique people who purchased item 104 over the year.
I have 50,000 transactions for the year and one to twenty two items per purchase. There are 1,700 total items and 15,000 individuals with unique id's. I originally had the items in one excel cell but split them each into their own cell.
I even imported the data into access thinking I could use the unique individual id's in some way but I am stuck.
How can I find the unique number of people who purchased item 108?