Welcome Guest
Log In | Register )
You last visited December 7, 2016, 11:24 am
All times shown are
Eastern Time (GMT-5:00)

help excel

Topic closed. 5 replies. Last post 4 years ago by reddog.

Page 1 of 1
51
PrintE-mailLink
Avatar
bgonçalves
Brasil
Member #92564
June 9, 2010
2122 Posts
Offline
Posted: September 28, 2012, 10:46 am - IP Logged

Each draw previous example macro generated a line of twenty numbers   But it has 8 or 9 numbers of a lottery earlier, can not be excluded   For the limit is 6 numbers for sweepstakes, anyone can?   Below is the list of 30 official sweepstakes = 03 09 12 35 38 42 44 46 51 53 60 64 67 75 81 84 90 93 99 00 09 10 19 20 21 26 27 29 32 46 50 60 62 66 68 81 96 98 99 00 12 19 24 26 32 40 41 44 46 47 61 62 64 66 70 84 89 93 94 95 02 05 11 13 14 27 29 33 36 44 48 54 58 60 64 66 68 70 77 78 04 06 14 17 24 35 53 56 58 59 60 63 64 67 69 73 74 78 93 00 03 16 19 20 26 30 31 34 37 60 71 73 74 77 78 80 84 87 91 97 07 17 21 24 32 39 45 48 49 50 53 57 59 62 64 74 85 87 97 98 03 04 10 12 25 34 35 38 42 53 54 60 63 66 74 75 77 81 82 93 06 14 15 22 24 27 35 43 53 54 60 61 63 78 80 87 89 98 99 00 04 17 20 22 24 25 27 30 33 34 43 45 48 50 56 63 69 71 78 98 05 11 13 15 18 20 25 26 45 46 47 49 62 68 70 79 89 92 96 99 02 05 08 10 21 23 25 35 39 41 45 46 47 54 63 77 78 79 80 83 03 04 13 16 27 33 34 46 53 54 58 59 62 67 68 73 74 85 96 99 01 02 04 10 23 25 26 28 30 38 40 43 44 52 59 69 82 85 88 93 04 11 12 13 14 15 20 25 28 29 32 34 41 45 49 53 60 63 67 81 01 02 03 07 10 14 16 19 23 38 44 49 53 61 67 68 79 85 97 98 01 02 06 09 15 18 21 26 32 34 42 50 54 56 59 62 67 68 76 93 01 08 11 14 23 24 25 27 30 36 39 47 57 61 67 75 80 81 87 91 15 19 24 26 36 37 43 48 55 58 60 69 72 74 80 81 87 92 95 00 08 15 16 33 41 46 47 48 50 51 52 55 57 63 72 76 79 84 89 90

Anular edições
    Avatar
    Charlotte
    United States
    Member #42106
    June 27, 2006
    59 Posts
    Offline
    Posted: September 28, 2012, 4:24 pm - IP Logged

    dr san,

     

    Dude I don't think I nor anyone else here quite understand what you are asking help for. 

     

    I see that you have an output of about 30 different drawings,  each with 6 numbers.  What are you wanting to do in excel with the output of this macro's activity?  Are you looking to just get a count of the number of times a particular number appears in the total population of the output?

     

    CountingMan

      Avatar
      bgonçalves
      Brasil
      Member #92564
      June 9, 2010
      2122 Posts
      Offline
      Posted: September 28, 2012, 5:27 pm - IP Logged

      dr san,

       

      Dude I don't think I nor anyone else here quite understand what you are asking help for. 

       

      I see that you have an output of about 30 different drawings,  each with 6 numbers.  What are you wanting to do in excel with the output of this macro's activity?  Are you looking to just get a count of the number of times a particular number appears in the total population of the output?

       

      CountingMan

      Hello, MAN, thanks for the post to see when it will be easy to understand ok!!, My lottery numbers ok uses 100 00-99, 20 numbers are drawn, I'm noticing this pattern
        Repeats of a draw for another 4-6 numbers, then the macro will do so, a file generated many games, a file of 1000 or more games, the macro will filter
        With the registration of some 30 drawings nd 40 raffles, a maximum of up to 6 numbers of the lottery
        Earlier, then the macro sees a game with 8 or 10 numbers from previous draws
        She'll delete this bet, so instead of generating sets, filtering, generates first games then filtered with the filter criteria,
        In the previous post google did not put on a list, but a list of the 30 latest sweepstakes

        reddog's avatar - patch
        Greensboro, North Carolina
        United States
        Member #1616
        June 5, 2003
        1285 Posts
        Offline
        Posted: September 28, 2012, 8:24 pm - IP Logged

        You must be on to something because you have been given 5 stars by a member.

          Avatar
          bgonçalves
          Brasil
          Member #92564
          June 9, 2010
          2122 Posts
          Offline
          Posted: September 28, 2012, 8:41 pm - IP Logged

          You must be on to something because you have been given 5 stars by a member.

          Hello, reddog, who decides for 5 stars is the owner of the forum, TODD, ok   I'm not connected to anyone!! I die in southern Brazil, I have a problem   With the translation of google, google, exchange words and synonyms, the forum is a friendly place to talk with friends, it has very experienced people in the forum   not care about the stars,

            reddog's avatar - patch
            Greensboro, North Carolina
            United States
            Member #1616
            June 5, 2003
            1285 Posts
            Offline
            Posted: September 29, 2012, 10:42 am - IP Logged

            Hello, reddog, who decides for 5 stars is the owner of the forum, TODD, ok   I'm not connected to anyone!! I die in southern Brazil, I have a problem   With the translation of google, google, exchange words and synonyms, the forum is a friendly place to talk with friends, it has very experienced people in the forum   not care about the stars,

            What I wrote was to translate that I was saying a good thing to you. OK ?