How often my customers are buying from me?

[BeepBeep]

Hi All,

Good morning..!

I have an Excel data with columns OrderDate, Customer, Sales. I want to use this data for a Pivot table. So I need a formula in a column which gives me information about "How often the customers are buying my products".

Some examples of transactions.

A. Mr. John bought Product-A on July 12, 2012.
B. John bought Product-B on Aug 24, 2012.
C. Again he bought Product-C Dec 25, 2012.

In the row of Txn-B, I need a difference between the Date of Txn-A and Txn-B i.e. 43 days
In the row of Txn-C, I need a difference between the Date of Txn-B and Txn-C i.e. 123 days and it goes on. Is it possible with in Excel or am I asking too much??

Thanks
BeepBeep

 

[chicagocomputerclasses]

I don't believe that is true, as long as the dates for each customer are in ascending order it should work fine!

That's what I meant, but didn't phrase it well

 

[gaz_chops]

Lol no worries, good catch on the blanks, missed that!!

 

[chicagocomputerclasses]

What bugs me is that the OP should probably identify the customers that never ordered again to get more meaningful marketing perspective.
If the objective is to find what is our average return rate/timeframe for returning customers than this report should be fine.

Not that it has anything to do with your formula

 

[gaz_chops]

Yea guess it depends on what there aim is!