Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Displaying all combinations of a range of numbers | Excel Worksheet Functions | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Macro to add numbers to create combinations that equal certain amo | Excel Discussion (Misc queries) | |||
Function generating all possible combinations of set of numbers | Excel Worksheet Functions | |||
combining several individual cells of numbers into one cell | Excel Worksheet Functions |