Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combinations of numbers sum to a given amount? | Excel Worksheet Functions | |||
Counting combinations of numbers | Excel Discussion (Misc queries) | |||
solving for all possible combinations of a set of numbers | Excel Worksheet Functions | |||
combining numbers into combinations | Excel Worksheet Functions | |||
Find combinations of numbers to equal a value | Excel Worksheet Functions |