Split data

[jan]

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

[jan]

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

[jan]

because not answered the last questions, any questions? only comes mensagam warning.