Generating Permutations and Combinations

e4excel · #1 06-27-2009, 01:11 PM

Hi Forum,

Need help to generate Series of Items in different Permuation & Combinations..

For Ex:- If there are three Items.. A B C and forming a group of 2
then the the total no of combinations would be permut(3,1) = 6...

I need this to be shown as follows depending on the no of itmes and no of group no=2 in this case...

Permuations & Combinations are as follows:

AB
AC
BC
CA
CB
BA

martindwilson · #2 06-27-2009, 02:01 PM

try this
http://www.ne.jp/asahi/math.edu/ami/myprog/jk_eng.htm
having said that i notice your other thread was locked beacause of the title
and to be truthful i cant see a lot of difference between that title and this one!

e4excel · #3 06-30-2009, 04:11 AM

You are right..!
Martin..there's little difference in both the threads as the "Need Help " is taboo i did away with it and retained the rest and as far as the explanation goes, I think that was not much of rule-breaker so I stayed with the same..

Thanks a lot for the solution, that file's amazing , but the only difficulty I am facing is to get a Permutations and Combinations of Proper Nouns or Words..

Likes Lets say Jack,Jill and Jane..

It considers all the individual alpahabets and not the words seperately., though I do admit in the example mentioned I had taken only Single-Alphabets as It would have been tedious to put names and show their Permutations and Combinations even in the example..

So can anything be done about the same...

Warm Regards
e4excel

martindwilson · #4 06-30-2009, 04:40 AM

it works with numbers0-9 as it treats them just as characters so put in numbers to = your text
say 1.2.3 for jane.mick.bob
then use find replace replace 1 with jane and so on.

e4excel · #5 06-30-2009, 10:58 AM

Quote:

Originally Posted by martindwilson

it works with numbers0-9 as it treats them just as characters so put in numbers to = your text
say 1.2.3 for jane.mick.bob
then use find replace replace 1 with jane and so on.

THanks a Lot Martin...
I shall tryth that but does that mean I can only try 0-9 items only what If I were to try for A Cricket Combination comprising of 11 team players like which team would be better of the Selection of 15 members..

This file's good but is there a Non-VBA solution which can be personlized or tailor-made file which can be tweaked for one's requirement..

Thanks...

martindwilson · #6 06-30-2009, 12:43 PM

there are plenty of other characters !"£$%^&*()_+ to use!
id suges you use that
then text to columnd to soplit then find replace.

e4excel · #7 06-30-2009, 01:34 PM

Dear martin,

Yes I would need to anyways use that "Text To Columns" options but is there a Formula Type Solution wherein I make the File ready and Just allot Cell-Spaces to put the Items and No of Items and the Required Permutation and Combination appears below..

What Im trying to make a file which takes atleast 15 Items and then Displays the Permutation and Combination below..

If there is I really would appreciate help on the same and otherwise the file provided is indeed very good...

martindwilson · #8 06-30-2009, 03:07 PM

youd have trouble with permutations your spread sheet would run out of rows on large ones.
i dont know if there is a formula solution but if there is it would prob take ages to calculate
last time we had a similar question
SHG had a solution

e4excel · #9 07-01-2009, 04:07 PM

Quote:

Originally Posted by martindwilson

youd have trouble with permutations your spread sheet would run out of rows on large ones.
i dont know if there is a formula solution but if there is it would prob take ages to calculate
last time we had a similar question
SHG had a solution

Any possiblity of getting that solution or the link for that Query where SHG had offered a solution...

martindwilson · #10 07-02-2009, 06:55 AM

no idea mate,youd have to do a search ane trawl through his posts!

e4excel · #11 07-02-2009, 10:50 AM

Not that I had not tried but in a similar query, SHG had removed the attachment and other files are slightly different from my requirement..

But anyways thanks a lot that file's still very good but it could have been an icing over the cake if it had been in a Formulaic solution...

Welcome to the Excel Forum

Forum Statistics