help macro excel 2010

Reply #4

dr san — Fri, 23 Aug 2013 03:16:15 GMT

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... [ More ]

Reply #3

SergeM — Thu, 22 Aug 2013 15:36:22 GMT

I am only replying to the how to question.

Reply #2

dr san — Wed, 21 Aug 2013 01:27:47 GMT

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 exampl... [ More ]

Reply #1

SergeM — Tue, 20 Aug 2013 23:01:33 GMT

Split over six cells.

0 1 0 2 0 3

Count the digits for each digit,

if three occur, then eliminate.

help macro excel 2010

dr san — Tue, 20 Aug 2013 13:48:33 GMT

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