Hi there. I am trying to figure out how many of my current database repurchased from us in the last month.
I have 3 columns of data at the moment.
Column one is about 10,000 unique client id's of my database in no particular order.
Column two has 1,000 client id's of those who have purchased in the last month (with duplicate entries, as some have purchased multiple times in the last month) in no particular order.
Column three has unique order numbers matched to the client id's in Column two.
I am trying to figure out the following:
How many of the sales in the last month came from existing clients and new clients?
How many of those who purchased did so more than once?
Is there a way this can be done? I have tried playing with pivot tables and removing/selecting duplicate data using asap tools but i've not been able to find a way to give me the above results.
Any help is much appreciated. I am using Excel 2007.
Cheers
J
I have 3 columns of data at the moment.
Column one is about 10,000 unique client id's of my database in no particular order.
Column two has 1,000 client id's of those who have purchased in the last month (with duplicate entries, as some have purchased multiple times in the last month) in no particular order.
Column three has unique order numbers matched to the client id's in Column two.
I am trying to figure out the following:
How many of the sales in the last month came from existing clients and new clients?
How many of those who purchased did so more than once?
Is there a way this can be done? I have tried playing with pivot tables and removing/selecting duplicate data using asap tools but i've not been able to find a way to give me the above results.
Any help is much appreciated. I am using Excel 2007.
Cheers
J