Excel question

[febausa]

Draw ball ball ball ball ball
date #1 #2 #3 #4 #5 # 1 2 3 4 5 6 7 ,,, number until 75

11/1/2013 37 35 50 75 39
11/1/2013 17 24 20 65 68
11/1/2013 69 12 49 73 54
11/1/2013 49 35 32 62 67

12/24/2013 26 59 27 2 6 2 6
12/24/2013 57 71 33 1 31 1
12/24/2013 58 75 1 70 3 1 3
12/24/2013 73 53 58 34 23

1/21/2014 43 44 71 38 55
1/21/2014 24 5 65 4 30 4 5
1/21/2014 22 74 39 44 30
1/21/2014 45 33 8 52 23

2/14/2014 6 32 60 23 30 6
2/14/2014 75 45 3 46 57 3
2/14/2014 69 42 15 38 45
2/14/2014 20 35 28 71 72







example for use "elapsed time analysis" i want to do automatically.

 

[shg]

What is your question?

 

[febausa]

Ii want to do "elapsed time analysis" automatically.

I want "elapsed time analysis", I want"

Draw Skips are the number of drawings or intervals between draws when the Regular number(s), 1 to 75, was NOT picked. ​

Draw ball ball ball ball ball
date #1 #2 #3 #4 #5 number 1 2 3 4 5 6 7 ,,, number until 75


12/24/2013 26 59 27 2 6 2 6
12/24/2013 57 71 33 1 31 1
12/24/2013 58 75 1 70 3 1 3
12/24/2013 73 53 58 34 23


1/21/2014 43 44 71 38 55
1/21/2014 24 5 65 4 30 4 5
1/21/2014 22 74 39 44 30