Results 1 to 5 of 5

Thread: Generate Random Groups Of 3 Digits At Most Two Digits Of The Last 200 Draws

  1. #1
    Junior Member
    Join Date
    Jun 2012
    Posts
    20
    Rep Power
    0

    Generate Random Groups Of 3 Digits At Most Two Digits Of The Last 200 Draws

    Hello, can you help me please create groups of 3 digits at most one to two digits
    * List of base (yellow) that goes 01-200 sweepstakes if you can put another value
    * From 01 to 150, need a button to choose the limit, the list I will always update with
    * New sweepstakes, starting from the last one can draw about 200 above
    Then generate random formations on the following criteria, at most two digits of the boundary marked 01-200, can not generate the three groups with base list, ok
    * Purpose of this group is to have a 3 digit limit 01-200
    Attached Files Attached Files

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    659
    Rep Power
    13
    Quote Originally Posted by jan View Post
    Hello, can you help me please create groups of 3 digits at most one to two digits
    * List of base (yellow) that goes 01-200 sweepstakes if you can put another value
    * From 01 to 150, need a button to choose the limit, the list I will always update with
    * New sweepstakes, starting from the last one can draw about 200 above
    Then generate random formations on the following criteria, at most two digits of the boundary marked 01-200, can not generate the three groups with base list, ok
    * Purpose of this group is to have a 3 digit limit 01-200
    I have read your description several times, but unfortunately I am not completely clear on what you are asking. Let me try and rephrase thing and you tell me how I did...

    1) You want the program to ask you for how many random numbers to generate.

    2) You want that many 3-digit numbers generated and (I'm guessing here) you want those number to be unique.

    3) The generated numbes should be placed after the numbers that are already existing on the sheet.

    Okay, now, what I am unclear on is this... assuming I am correct on #2 above (generated numbers are to be unique), how does that uniqueness relate to the numbers already on the sheet... do the new numbers have to not repeat against the existing numbers or only not repeat for the number of random numbers asked for in #1 above.

  3. #3
    Junior Member
    Join Date
    Jun 2012
    Posts
    20
    Rep Power
    0
    Hello, thanks rick for the message, we in parts ok, I did a statistical
    * The pick3 that hardly starting the last draw about 200 sweepstakes ago, does not repeat
    *** The result of 3 digits of pick3, may repeat one or two, then it is easy to create
    * Randomly, but many groups can not have the same 3-digit base list
    * So if the base list (which is the last two hundred sweepstakes ago) have the group 458
    * In the random groups can have 458. Because it has three digits the list base.bom
    These random groups which can not be 3digitos (which is full output)
    * From the list, may also have criteria filters at most one of each digit
    * Condition below = I. 1. Mostly to All HIGH (5,6,7,8,9) ..... or

    2. All Moslty to LOW (0,1,2,3,4)



    II. 1. Mostly to All EVEN (0,2,4,6,8) or ...

    2. Mostly to All ODD (1,3,5,7,9)



    III. 1. Mostly to All digits IN (3,4,5,6,7) ...... or

    2. Mostly to All OUT (0,1,2,8,9)



    IV. 1. Cosecutive Pair, 0-9, is consec

    2. NO Consecutive Pair

  4. #4
    Junior Member
    Join Date
    Jun 2012
    Posts
    20
    Rep Power
    0
    hello, rick!!Lets see what your doubts? thank you

  5. #5
    Junior Member
    Join Date
    Jun 2012
    Posts
    20
    Rep Power
    0
    Hello, ricy help me please,
    a lottery is 25/11 ok
    01,02,05 .... up to 11 numbers, 11 numbers sé plays on the line
    Need combinations of 11 but has not within the trios combination without repetition
    The game is 01-25, can not have such 03,15,24 = can not have this trio because it has no repetition, now the pair can, and so with other trios example = 07,19,25 can not be within the combination of 11 numbers by this trio, 07.19, 25 does not repeat the digits, may not have the pair may = can generate many combinations of 11. Please!
    Example of a training =
    = 01,02,03,05,06,07,11,15,19,22,23 has trios = no repeat this training can
    01 02 05 06 07 08 09 19 21 24 25 = can not (delete) because it has 07,19,25, delete this type of combination of 11 numbers

Similar Threads

  1. Replies: 2
    Last Post: 07-18-2013, 03:34 AM
  2. Replies: 4
    Last Post: 06-09-2013, 01:47 AM
  3. Sum Of The Digits In A Cell Using Formula
    By venkat1926 in forum Excel Help
    Replies: 0
    Last Post: 04-30-2013, 07:11 PM
  4. Replies: 8
    Last Post: 04-29-2013, 08:36 PM
  5. Generate random numbers in Excel
    By Mahesh in forum Excel Help
    Replies: 3
    Last Post: 10-06-2011, 11:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •