Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to create a array or matrix of all the combinations or
permutations of a certain set in an Excel spreadsheet. I have 12 numbers (1-12) and I want to create array with all the combination of 3 out of 12. So it would look like this: 1,2,3 2,1,3 3,2,1 ...., etc 12,11,10...Well, you get the idea. How does one create this array? I know how to use COMBIN() and PERMUT() but those just give a number. I want the full array. -Don |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PERMUTATION AND COMBINATION | Excel Discussion (Misc queries) | |||
Permutation combination of a 4 digit no | Excel Discussion (Misc queries) | |||
Creating a Combination Chart | Charts and Charting in Excel | |||
Permutation and combination | Excel Discussion (Misc queries) | |||
Combination/Permutation Generation | Excel Programming |