Combinations numbers ecarts(Variation)
 

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