• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate repeat figures against database.

javman

New Member
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
 
Hi ,


I have no idea about pivot tables , but this can certainly be done using formulae ; can you check the file here ?


https://www.dropbox.com/s/0cedq8q9qbwom0s/Example_javman.xlsx


Narayan
 
Back
Top