AKYRA
05-03-2010, 02:33 PM
iŽd like to know if someone can give me help.
iŽd like to find a code for vb/vba/ excel that generates all possible combinations from a given set of numbers.
the order of the numbers, in themselves is unimportant, irrelevant to the problem.
for example, find/create all possible combinations from 20 numbers that forms groups of 15 elements.
data: 10 11 99 28 67 20 55 74 45 48 85 60 51 30 41 35 78 83 93 64
another example, find/create all possible combinations from 80 numbers that forms groups of 5 elements.
data: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
another example, find/create all possible combinations from 60 numbers that forms groups of 4 elements.
data:1 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
I think that's possible to make this in visual basic/ excel but I donŽt know how to start.
I'm looking forward to receiving good news.
Thanks in advance
iŽd like to find a code for vb/vba/ excel that generates all possible combinations from a given set of numbers.
the order of the numbers, in themselves is unimportant, irrelevant to the problem.
for example, find/create all possible combinations from 20 numbers that forms groups of 15 elements.
data: 10 11 99 28 67 20 55 74 45 48 85 60 51 30 41 35 78 83 93 64
another example, find/create all possible combinations from 80 numbers that forms groups of 5 elements.
data: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
another example, find/create all possible combinations from 60 numbers that forms groups of 4 elements.
data:1 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
I think that's possible to make this in visual basic/ excel but I donŽt know how to start.
I'm looking forward to receiving good news.
Thanks in advance