Explanation the attach files
The draw-date is repeated 6 times but with different numerous, differentiate it is good; could differentiate the first draw-date automatically excel add "-A", the second draw-date automatically add excel "-B”, and so successively until the last draw-date repeating excel automatically adding "-F".
The data show is input information, the first six column is real and historic data column ; in other words, the columns title: DRAW DATE, BALL #1, BALL #2, BALL #3, BALL #4, and BALL #5. The remaining columns are defined by the input information.
I will make a description of reasoning:
The columns title BALL NUMBER:
BALL NUMBER 1: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 2: due to number is repeated win three times, appears on date repetition (win date) 3/19/2014, and 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
BALL NUMBER 3: due to number is repeated win two times, appears on date repetition (win date) 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
BALL NUMBER 4: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 5: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 6: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 7: due to number is repeated win two times, appears on date repetition (win date) 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
BALL NUMBER 8: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 9: due to number is repeated win two times, appears on date repetition (win date) 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
BALL NUMBER 10, 11,12,13,14 : due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 15: due to number is repeated win three times, appears on date repetition (win date) 3/15/2014, and 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
This line of reasoning is repeated in the following 44 numbers.
The row (line) number repetition writes the number that is repeated winner.
The draw-date is repeated 6 times but with different numerous, differentiate it is good; could differentiate the first draw-date automatically excel add "-A", the second draw-date automatically add excel "-B”, and so successively until the last draw-date repeating excel automatically adding "-F".
The data show is input information, the first six column is real and historic data column ; in other words, the columns title: DRAW DATE, BALL #1, BALL #2, BALL #3, BALL #4, and BALL #5. The remaining columns are defined by the input information.
I will make a description of reasoning:
The columns title BALL NUMBER:
BALL NUMBER 1: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 2: due to number is repeated win three times, appears on date repetition (win date) 3/19/2014, and 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
BALL NUMBER 3: due to number is repeated win two times, appears on date repetition (win date) 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
BALL NUMBER 4: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 5: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 6: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 7: due to number is repeated win two times, appears on date repetition (win date) 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
BALL NUMBER 8: due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 9: due to number is repeated win two times, appears on date repetition (win date) 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
BALL NUMBER 10, 11,12,13,14 : due to no number is repeated win, nothing appears on date repetition.
BALL NUMBER 15: due to number is repeated win three times, appears on date repetition (win date) 3/15/2014, and 3/19/2014. Note the first date (3/15/2014) no show due to so far the number is not repeated as winner.
This line of reasoning is repeated in the following 44 numbers.
The row (line) number repetition writes the number that is repeated winner.