LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Creating a Combination or Permutation Array in Excel

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PERMUTATION AND COMBINATION FC Excel Discussion (Misc queries) 3 August 30th 07 04:14 AM
Permutation combination of a 4 digit no [email protected] Excel Discussion (Misc queries) 2 August 20th 07 07:19 PM
Creating a Combination Chart Bob Charts and Charting in Excel 5 September 1st 06 01:06 PM
Permutation and combination vishu Excel Discussion (Misc queries) 2 May 19th 05 07:47 AM
Combination/Permutation Generation Tom Ogilvy Excel Programming 0 September 9th 04 04:34 PM


All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"