Combinations numbers ecarts(Variation)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top