• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Number repetition

febausa

Member
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.
 

Attachments

  • example-data-01.xlsx
    13.4 KB · Views: 12
Hi ,

I am not able to understand the logic of the date repetition ; suppose a number , say 2 , appears 3 times in the draws on 3/15/2014 , and 3 times in the draw on 3/19/2014 ; what would be the date repetitions ?

Can you indicate the number of times the date 3/15/2014 would appear , and the number of times the date 3/19/2014 would appear ?

Narayan
 
This would work in "number repetition" while in another condition it will take to understand myself.

=IF(COUNTIF(H$3:H$8,H$2)>=2,$A$3,IF(COUNTIF(H$9:H$13,H$2)>=2,$A$13,IF(COUNTIF(H$3:H$13,H$2)>=2,$A$13,"")))
 
Back
Top