See the attached. Column M:U/Y:AG is just used to make sure number are not repeating/missing. Press F9 key to generate the random numbers.
Copy column J & paste across as needed.
See the attached. Column M:U/Y:AG is just used to make sure number are not repeating/missing. Press F9 key to generate the random numbers.
Copy column J & paste across as needed.
Hello HASEEB fantastic, good job, perfect, thank you
hello, it's pretty easy to have two groups of 45 numbers each, these groups are formed Groups ranging from 01 to 98 For couples or capicuas reversed, eg 01.10 or 32.23 etc. .. A group is 01.23, 48, 59, 85 ... In the other group has = 10 32 84 59 58 ... Group and one group of two inverted. HASSEB, the macro will select 20 numbers in each group, and form lines of 40 numbers But beware! can not generated line numbers 40 have a couple example 32.23 Or have 23 or 32, numca the two together and so ok with 45 other couples or inverted capicuas Then 01-98 have 45 possible matches, which are the two groups, Can generate some 1200 lines or more Example = 01 03 05, ........ 12.45 Figures 40 until This example = 01,10,23,32 ..... can not delete can not have both numbers or 01 or 10 this example may not appear, ok Then take 20 macro numbers of each group of forty gerndo lines without the inverted bed, or having or having one another along the two numca please send an already planilia activity with command button here are two groups
01 02 03 04 05 06 07 08 09 10 20 30 40 50 60 70 08 90
12 13 14 15 16 17 18 19 23 21 31 41 15 61 71 81 91 32
24 25 26 27 28 29 34 35 36 42 52 62 72 82 92 43 53 63
37 38 39 45 46 47 48 49 56 73 83 93 54 64 74 84 94 65
57 58 59 67 68 69 78 79 89 75 85 95 76 86 96 87 97 98
01 02 03 04 05 06 07 08 09
12 13 14 15 16 17 18 19 23 grup 01
24 25 26 27 28 29 34 35 36
37 38 39 45 46 47 48 49 56
57 58 59 67 68 69 78 79 89
10 20 30 40 50 60 70 80 90
21 31 32 41 42 43 51 52 53 grup 02
54 61 62 63 64 65 71 72 73
74 75 81 82 83 84 85 86 76
87 91 92 93 94 95 96 97 98
Hello, the row of 40 numbers must have the following criteria = Have a maximum of 20 pairs = 20 and odd Choosing a maximum of three pre three column line and each of the two groups
Hello, Rick, here and generate rows of 20 numbers, 5 numbers each frame But not to repeat the positions, = Sample a part five numbers 01,12,21,32,41, can not occupy The positions represented by the same letter Example if the number 01 is the letter A is not three other tables can not be the letter A That is the same position. And so with others, are rows of 20 numbers, the positions are not repeated
A B C D E A B C D E
F G H I J F G H I J
K L M N O K L M N O
P Q R S T P Q R S T
U V X Y Z U V X Y Z
A B C D E A B C D E
F G H I J F G H I J
K L M N O K L M N O
P Q R S T P Q R S T
U V X Y Z U V X Y Z
1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56 57 58 59 60
61 62 63 64 65 66 67 68 69 70
71 72 73 74 75 76 77 78 79 80
81 82 83 84 85 86 87 88 89 90
91 92 93 94 95 96 97 98 99 0
Hello, this is easy to separate the last digit and add so example 1st 2nd 3rd 4th 5th 6th 12 15 24 32 42 56 last digit = 2,5,4,2 2.6 Summing the 1st position with the 2nd = 25 Sum a3 th position with 3rd = 42 Add up the 5th and 6th = 26 Up to the demonstration in columns alongside, and paste option Make a planilia and activate. I have excel 2010, Windows Seven 02 04 05 27 49 59= 24 57 99
02 04 05 27 49 59
03 04 08 11 47 49
03 36 40 46 58 60
07 27 39 52 55 57
06 21 28 31 33 43
14 25 28 45 53 58
09 11 21 49 53 54
02 05 12 13 25 35
02 05 17 18 54 59
05 12 36 45 50 58
03 14 52 55 57 60
11 27 30 40 44 57
05 13 16 17 27 55
07 09 23 44 46 55
02 18 30 31 45 56
27 35 36 37 42 59
12 28 38 39 51 56
18 27 32 43 50 52
22 29 31 43 50 54
01 16 28 39 44 57
04 19 27 28 29 31
07 12 19 34 40 53
02 08 12 28 33 43
04 18 24 28 39 44
11 16 24 35 46 50
05 11 17 19 44 48
29 48 52 54 55 58
03 04 07 15 27 56
14 32 33 40 42 51
34 39 43 56 57 60
09 26 34 43 53 54
because not answered the last questions, any questions? only comes mensagam warning.
Can't make out the logic you are trying to explain. Can you rephrase?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hello, it is quite easy step .1 separate the last digit of the list results okstep 2, add the digits in every twoExampleResult =01 36 25 12 02 48 = join the last digit = 1.2 2.5 6.8So we have 6 digits together in twos we have 12 pairs 3 25 68Cause or other sweepstakes and option to put more sweepstakes, to separate macroIn the last 3 digit pairs
Posting Permissions
Reply With Quote
Bookmarks