sort help

[Scott_20]

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

[Michael Schulte zur Sur]

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]

Michael
Yes, that is exactly correct.
thanks
scott

[vetriselvan s]

No u cant do that in Excel directly
u have to write a script for that,or an macro

[Joseph T. Wyckoff]

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.