Frequency analysis - number of days between each occurance

[msin88]

Hi,

I have list of data where I need to analyze the frequency of when my employees are buying mobile phones.

I have a list consisting of the following information:
- Employee
- Date of purchase

I want to find out how often each employee orders a new phone (number of days between each purchase) and also an average for the whole company.
I assume there is a "quick" solution to this, but somehow I cannot figure out how to do this the easiest way. I have put the data into a pivot table with the dates listed for each employee, but it does not solve my problem.

Hope someone can help me or at least guide me in the right direction.

Thanks!

 

[VBA Geek]

here is a simple way for you: sort your table first by column Employee and then by Date of purchase (oldest to newest). then apply these formulas

Excel 2010
	A	B	C	D	E	F
1	Emp	Date of Purchase	DAYS		EMP	AVG BY EMPLOYEE
2	AAAA	2/7/2018	FALSE		AAAA	4
3	AAAA	2/12/2018	5		BBB	7
4	AAAA	2/15/2018	3
5	BBB	2/7/2018	FALSE
6	BBB	2/14/2018	7
Sheet2

Cell Formulas
Range	Formula
F2	=AVERAGEIF($A$2:$A$6,$E2,$C$2:$C$6)
F3	=AVERAGEIF($A$2:$A$6,$E3,$C$2:$C$6)
C2	=IF(COUNTIFS(A$2:A2,A2)=1,FALSE,B2-B1)
C3	=IF(COUNTIFS(A$2:A3,A3)=1,FALSE,B3-B2)
C4	=IF(COUNTIFS(A$2:A4,A4)=1,FALSE,B4-B3)
C5	=IF(COUNTIFS(A$2:A5,A5)=1,FALSE,B5-B4)
C6	=IF(COUNTIFS(A$2:A6,A6)=1,FALSE,B6-B5)

 

[msin88]

Thank you! Worked perfectly.