cancel
Showing results for 
Search instead for 
Did you mean: 

sort help

Scott_20
Occasional Advisor

sort help

I trying to create a sort for 5 chords:
G C D A E and I'd like to output all possible combinations. Can this be done automatically in excel or does any have script that can do this?
thanks
scott
I'm ok
4 REPLIES
Michael Schulte zur Sur
Honored Contributor

Re: sort help

Hi,

excuse me, if I do not understand your question. Do you want a list of all combinations from those 5 characters?

greetings,

Michael
Scott_20
Occasional Advisor

Re: sort help

Michael
Yes, that is exactly correct.
thanks
scott
I'm ok

Re: sort help

No u cant do that in Excel directly
u have to write a script for that,or an macro
Joseph T. Wyckoff
Honored Contributor

Re: sort help

Wow, this is math stuff... permutations and combinations. neat stuff, but details matter.

You may be able to find a free statistical package on the web to plug into excel, to help you manage this.

Programmatically thats gonna be pretty simple, but I think you need to define the problem a little better...

Is G G G G G a valid combination?

Is G A G G G valid?
-if so why is this valid and not the first
-a rule might be no more than four identical in a row...



--

The simplest case is each must appear, and appear only once...

The you have 5 x 4 x 3 x 2 x 1 = 120 combinations.

Thats quite a list.
Omniback and NT problems? double check name resolution, DNS/HOSTS...