Welcome Guest
You last visited January 22, 2017, 1:10 pm
All times shown are
Eastern Time (GMT-5:00)

# help macro excel 2010

Topic closed. 4 replies. Last post 3 years ago by dr san.

 Page 1 of 1
bgonÃ§alves
Brasil
Member #92564
June 9, 2010
2136 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

Economy class
Belgium
Member #123700
February 27, 2012
4035 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.

bgonÃ§alves
Brasil
Member #92564
June 9, 2010
2136 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

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: August 22, 2013, 11:36 am - IP Logged

I am only replying to the how to question.

bgonÃ§alves
Brasil
Member #92564
June 9, 2010
2136 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

 Page 1 of 1