Welcome Guest
Log In | Register )
The time is now 12:48 pm
You last visited October 21, 2014, 12:42 pm
All times shown are
Eastern Time (GMT-5:00)

help macro excel 2010

Topic closed. 4 replies. Last post 1 year ago by dr san.

Page 1 of 1
PrintE-mailLink
Avatar
bgonçalves
Brasil
Member #92566
June 9, 2010
1502 Posts
Offline
Posted: August 20, 2013, 9:48 am - IP Logged

Hello, I need help on this macro, I have a file of 2,300 trios going 01-25
I need the macro separate trios with repeating digits example three
01 02 20 = yes, we have three zero digits
01 12  21 = yes we have three repeats digit (1) and so with others who have tresrepetiçao digit of the room composition,

  I will not put the list of 2300 because it is large, only the beginning and end
01 02 03
01 02 04
01 02 05
Bye....
23,24,25 = 2300 trios
  My excel 2010 in seven

    SergeM's avatar - alas
    Economy class
    Belgium
    Member #123705
    February 27, 2012
    2879 Posts
    Offline
    Posted: August 20, 2013, 7:01 pm - IP Logged

    Split over six cells.
    0 1 0 2 0 3
    Count the digits for each digit,
    if three occur, then eliminate.

      Avatar
      bgonçalves
      Brasil
      Member #92566
      June 9, 2010
      1502 Posts
      Offline
      Posted: August 20, 2013, 9:27 pm - IP Logged

      Split over six cells.
      0 1 0 2 0 3
      Count the digits for each digit,
      if three occur, then eliminate.

      Hello, ok,SERGEM  perfect, suggests you use Excel's filter? Ok I'll try!
        Thank you, sergem ever noticed this pattern in the power ball 5/59, which always
        It has a couple without repeating digit example = 02.35 and another pair with repeated digit
        15.45 ie have two pairs conditions with a pair digits repeated with each other and other
        Even without the digits repeated, and with 4 different numbers between pairs, as might be
        Doing this analysis, the two pairs of conditions? For example a pair (the digit repeated can give indications of the other pair) the pair of digit is not repeated, and vice versa, is a pattern to be seen, after missing a good number to close bets and bonuses Abola. thank you very much

        SergeM's avatar - alas
        Economy class
        Belgium
        Member #123705
        February 27, 2012
        2879 Posts
        Offline
        Posted: August 22, 2013, 11:36 am - IP Logged

        I am only replying to the how to question.

          Avatar
          bgonçalves
          Brasil
          Member #92566
          June 9, 2010
          1502 Posts
          Offline
          Posted: August 22, 2013, 11:16 pm - IP Logged

          Hello, the frequency positional order draw, can be done with the last digit, the number, with the pair and trio, example of the lottery pairs = 5/43 have 1.2 1.3 1.4 .. .. = 4.5 are ten positions of pairs and trios = 1,2,3, 1,2,4 1,2,5 ... 3,4,5 = 10 positions are trios

          Look at the example of 5/43 = 10,15,17,03,40 have here = digits = 0,1,3,4,5,7 = plus the digit only 6 digits of the ten digit possíves, we can see the frequency by position to pick up the repetition of a digit in the example 5/43 = repeated 3 times the digit (1) and three digits zeros