hello PAB=
digit
Code:
A- B- C- D- E- F- G H I J K L M N O P Q R S T
1 43 44 46 53 54 59 4 4 4 5 5 5 3 4 6 3 4 9
2 3 16 23 25 51 56 0 1 2 2 5 5 3 6 3 5 1 6
3 2 10 15 44 56 57 0 1 1 4 5 5 2 0 5 4 6 7
4 8 19 46 51 52 54 0 1 4 5 5 5 8 9 6 1 2 4
5 7 14 15 20 23 35 0 1 1 2 2 3 7 4 5 0 3 5
6 3 5 11 36 44 46 0 0 1 3 4 4 3 5 1 6 4 6
7 6 19 22 34 43 45 0 1 2 3 4 4 6 9 2 4 3 5
8 7 10 32 43 47 54 0 1 3 4 4 5 7 0 2 3 7 4
9 7 8 24 30 33 47 0 0 2 3 3 4 7 8 4 0 3 7
10 7 12 25 26 32 39 0 1 2 2 3 3 7 2 5 6 2 9
11 8 9 14 32 53 59 0 0 1 3 5 5 8 9 4 2 3 9
12 7 9 12 19 45 54 0 0 1 1 4 5 7 9 2 9 5 4
13 5 20 22 28 29 30 0 2 2 2 2 3 5 0 2 8 9 0 In H1 and copied across and down, =INT(A1/10)
In O1 and copied across and down, =MOD(A1,10)
Hello,PAB, the next step is to do so in a separate macro
In suits, so we have 6 digit = dismember in 20 positions possible
Example: type first = 1, 2, 3, 2, 4, 4
1, 2, 3, 1,2,4 1,2,5 1,2,6 ... until 4, 5.6 = 20 positions
1, 2, 2, 1 2.2 ... ... .... 2 4 4= digits firt dismembered
And the termiançoes also in 20 positions
LAST = 2, 5, 6, 7, 8,3
1,2,3 1,2, 4 ... 4,5,6 up to 20 positions
2,5,6 ........7,8,3
Do together in a macro and enable, I couldn't activate code
Here are the 20 positions =
123
124
125
126
134
135
136
145
146
156
234
235
236
245
246
256
345
346
356
456
digit
Code:
A- B- C- D- E- F- G H I J K L M N O P Q R S T
1 43 44 46 53 54 59 4 4 4 5 5 5 3 4 6 3 4 9
2 3 16 23 25 51 56 0 1 2 2 5 5 3 6 3 5 1 6
3 2 10 15 44 56 57 0 1 1 4 5 5 2 0 5 4 6 7
4 8 19 46 51 52 54 0 1 4 5 5 5 8 9 6 1 2 4
5 7 14 15 20 23 35 0 1 1 2 2 3 7 4 5 0 3 5
6 3 5 11 36 44 46 0 0 1 3 4 4 3 5 1 6 4 6
7 6 19 22 34 43 45 0 1 2 3 4 4 6 9 2 4 3 5
8 7 10 32 43 47 54 0 1 3 4 4 5 7 0 2 3 7 4
9 7 8 24 30 33 47 0 0 2 3 3 4 7 8 4 0 3 7
10 7 12 25 26 32 39 0 1 2 2 3 3 7 2 5 6 2 9
11 8 9 14 32 53 59 0 0 1 3 5 5 8 9 4 2 3 9
12 7 9 12 19 45 54 0 0 1 1 4 5 7 9 2 9 5 4
13 5 20 22 28 29 30 0 2 2 2 2 3 5 0 2 8 9 0 In H1 and copied across and down, =INT(A1/10)
In O1 and copied across and down, =MOD(A1,10)
Hello,PAB, the next step is to do so in a separate macro
In suits, so we have 6 digit = dismember in 20 positions possible
Example: type first = 1, 2, 3, 2, 4, 4
1, 2, 3, 1,2,4 1,2,5 1,2,6 ... until 4, 5.6 = 20 positions
1, 2, 2, 1 2.2 ... ... .... 2 4 4= digits firt dismembered
And the termiançoes also in 20 positions
LAST = 2, 5, 6, 7, 8,3
1,2,3 1,2, 4 ... 4,5,6 up to 20 positions
2,5,6 ........7,8,3
Do together in a macro and enable, I couldn't activate code
Here are the 20 positions =
123
124
125
126
134
135
136
145
146
156
234
235
236
245
246
256
345
346
356
456