P
PST
Combinations numbers ecart vba
HELLO
I want the ecart of each number in the combination if it possible
Min number = 1
Max number =70
row 1 >>> columns >>>ABCDEFGHJI >> combinations >>>10000 rows
row 1 >>> columns l to CC >>>> the number 1 to 70
rows 1 the titles
rows 2 to 10000 the data
For all the lines I would like to know the ecart for the numbers 1 has
70 when they appeared ,see a the end of the message
Row 1 Colum >> A = N1
Row 1 Colum >> B = N2
Row 1 Colum >> C = N3
Row 1 Colum >> D = N4
Row 1 Colum >> E = N5
Row 1 Colum >> F = N6
Row 1 Colum >> G = N7
Row 1 Colum >> H = N8
Row 1 Colum >> I = N9
Row 1 Colum >> J = N10
Row 1 Colum >> K = "Numbs to ecart"
Row 1 Colum >> L = 1
Row 1 Colum >> M = 2
Row 1 Colum >> N = 3
Row 1 Colum >> O = 4
Row 1 Colum >> P = 5
Row 1 Colum >> Q = 6
Row 1 Colum >> R = 7
Row 1 Colum >> S = 8
Row 1 Colum >> T = 9
Row 1 Colum >> U = 10
Row 1 Colum >> ,,,,,,, = ,,,,,,,
Row 1 Colum >> CB = 69
Row 1 Colum >> CC = 70
With that combinations
N1 N2 N3 N4 N5
1 2 3 4 10
1 2 3 4 11
1 2 3 4 12
1 2 3 4 13
1 2 3 4 14
1 2 3 4 15
1 2 3 4 16
1 2 3 4 17
1 2 3 4 18
1 2 3 4 19
Numbers 1 2 3 4 ecart 0
Numbers 10 ecart 9
Numbers 11 ecart 8
Numbers 12 ecart 7
Numbers 13 ecart 6
Numbers 14 ecart 5
Numbers 15 ecart 4
Numbers 16 ecart 3
Numbers 17 ecart 2
Numbers 18 ecart 1
thank you
HELLO
I want the ecart of each number in the combination if it possible
Min number = 1
Max number =70
row 1 >>> columns >>>ABCDEFGHJI >> combinations >>>10000 rows
row 1 >>> columns l to CC >>>> the number 1 to 70
rows 1 the titles
rows 2 to 10000 the data
For all the lines I would like to know the ecart for the numbers 1 has
70 when they appeared ,see a the end of the message
Row 1 Colum >> A = N1
Row 1 Colum >> B = N2
Row 1 Colum >> C = N3
Row 1 Colum >> D = N4
Row 1 Colum >> E = N5
Row 1 Colum >> F = N6
Row 1 Colum >> G = N7
Row 1 Colum >> H = N8
Row 1 Colum >> I = N9
Row 1 Colum >> J = N10
Row 1 Colum >> K = "Numbs to ecart"
Row 1 Colum >> L = 1
Row 1 Colum >> M = 2
Row 1 Colum >> N = 3
Row 1 Colum >> O = 4
Row 1 Colum >> P = 5
Row 1 Colum >> Q = 6
Row 1 Colum >> R = 7
Row 1 Colum >> S = 8
Row 1 Colum >> T = 9
Row 1 Colum >> U = 10
Row 1 Colum >> ,,,,,,, = ,,,,,,,
Row 1 Colum >> CB = 69
Row 1 Colum >> CC = 70
With that combinations
N1 N2 N3 N4 N5
1 2 3 4 10
1 2 3 4 11
1 2 3 4 12
1 2 3 4 13
1 2 3 4 14
1 2 3 4 15
1 2 3 4 16
1 2 3 4 17
1 2 3 4 18
1 2 3 4 19
Numbers 1 2 3 4 ecart 0
Numbers 10 ecart 9
Numbers 11 ecart 8
Numbers 12 ecart 7
Numbers 13 ecart 6
Numbers 14 ecart 5
Numbers 15 ecart 4
Numbers 16 ecart 3
Numbers 17 ecart 2
Numbers 18 ecart 1
thank you