Charlotte United States
Member #42,105
June 27, 2006
105 Posts
Offline
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?
bgonçalves Brasil
Member #92,560
June 9, 2010
3,779 Posts
Offline
Quote: Originally posted by CountingMan on Sep 28, 2012
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 forthepostto seewhenit will be easyto understandok!!,Mylotterynumbersokuses 10000-99,20numbersare drawn, I'm noticingthis pattern Repeatsof adraw foranother4-6numbers,then themacrowill doso,a filegeneratedmany games,a fileof 1000 ormore games,the macrowill filter Withthe registration ofsome 30drawingsnd40raffles,a maximumofup to 6numbersof thelottery Earlier,then themacroseesa game with8 or 10numbersfrompreviousdraws She'lldeletethis bet, so insteadof generatingsets, filtering,generatesfirstgamesthenfilteredwith thefilter criteria, In the previous postgoogledid not puton a list, but alist of the 30latestsweepstakes