G
Guest
but I do not know what words to search on to find it.
I have a set of x amount of numbers.... sometimes 10 some times 8.. I would
like to geta macro that can take those numbers and generate every possible 5
number combination.
ie.
A B C D E F G H
--- --- --- --- --- --- --- ---
1 2 3 4 5 6 7 8
A B C D E
--- --- --- --- ---
1 2 3 4 5
1 2 3 4 6
1 2 3 4 7
1 2 3 4 8
1 2 3 5 6
1 2 3 5 7
1 2 3 5 8
It would be on the same sheet (lets call it Sheet3)
Thank you for finding the code or helping me point to the location of the
right code.
David
I have a set of x amount of numbers.... sometimes 10 some times 8.. I would
like to geta macro that can take those numbers and generate every possible 5
number combination.
ie.
A B C D E F G H
--- --- --- --- --- --- --- ---
1 2 3 4 5 6 7 8
A B C D E
--- --- --- --- ---
1 2 3 4 5
1 2 3 4 6
1 2 3 4 7
1 2 3 4 8
1 2 3 5 6
1 2 3 5 7
1 2 3 5 8
It would be on the same sheet (lets call it Sheet3)
Thank you for finding the code or helping me point to the location of the
right code.
David