How to calculate Purchase Frequency

[purvaj_hegde@yahoo.co.in]

My boss has asked me to make a chart on the Purchase Frequency.


We have 1 Product and many distributors.


Can you please help me which formula do I use in excel for accurate results.

 

[sgmpatnaik]

@Purvaj


Hi


Firstly welcome to Chandoo.org Forums,


firstly i would like to advise you to please change your name it is too big


when ever you are going to post a question, it is better to search your question through the search box which is in upper right side of this forum may be some body ask the question and that was solved


It is better to give the more details and try to upload a sample workbook which is helpful to Forum Readers and Ninja's and you will get the better result from the Readers


Hop you will understand


Thanks


SP

 

[SirJB7]

Hi, purvaj_hegde@yahoo.co.in!

As sgmpatnaik wrote, may I suggest you to change your nick name? It's too long and it overlaps the comment area making it unreadable. If you want to keep your email address you can put it in the website field of your profile, then when clicking on you nick on any comment the user will be led to your email.

Regards!

 

[Luke M]

as for the actual questions, there's several ways you could go. The fastest way (and with lots of options) would be to put the data into a PivotTable and create a PivotChart. You could easily group things by customer/date and create some column or bar charts.