| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Permutation Output
Excel can calculate the possible permutations of 3 items out of a total of 5
items (60 possibilities). This is done easily enough using the PERMUT function. My Questiion: Can excel (perhaps using VBA???) ouput all of those permutations? For example: TIM, JIM, KIM, RIM, PIM these are the 5 data points. I need an output listing of all possible permutations of 3 (TIM/KIM/RIM; RIM/TIM/KIM;PIM/JIM/TIM; etc). Can Excel do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO YOU GET A "0" OUTPUT FROM A CELLTHAT IS THE PRODUCT OF A V. | Excel Discussion (Misc queries) | |||
| how create/maintain Excel "db" of client, output to Avery address. | Excel Discussion (Misc queries) | |||
| Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) | |||
| Formating output. | Excel Discussion (Misc queries) | |||
| Formating output. | Excel Worksheet Functions | |||
Threaded Mode
