I have a set of x amount of numbers.... sometimes 10 some times 8.. I would
like to 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 helping me.
Bookmarks