Split data

[jan]

Hello HASEEB fantastic, good job, perfect, thank you

[jan]

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

[jan]

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

[jan]

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