|Posted: October 2, 2015, 8:53 am - IP Logged|
In this request, row one starts with the PB drawing on Jan 18, 2012. There have been 387 drawings at the current matrix. I'm requesting a macro pro to create an animation or gif of each draw as a graph showing the accumulated total of each number drawn. The first frame shows the numbers in rows 1:1, including 6, 29, 34, 44 and 50. The ":" isn't ratio, it's excel speak. The second frame shows the sum of (or countif in excel) all numbers drawn in rows 1:2, including 12, 24, 43, 44 and 45, thus showing the number 44 jumping up to 2 on the graph. So on and so forth until the animation shows countif of all 59 numbers drawn in rows 1:387. For example, the numbers 1 and 2 have come up a total of 34 times each thus far, number 3 has come up 33 times, number 4 has come up 28 times, etc., etc., etc. Thank you!