topic Re: sort help in Operating System - Microsoft

sort help

Scott_20 — Wed, 28 Jul 2004 09:18:08 GMT

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

Re: sort help

Michael Schulte zur Sur — Wed, 28 Jul 2004 12:35:45 GMT

Hi,

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

greetings,

Michael

Re: sort help

Scott_20 — Wed, 28 Jul 2004 13:07:49 GMT

Michael
Yes, that is exactly correct.
thanks
scott

Re: sort help

vetriselvan s — Tue, 17 Aug 2004 03:02:38 GMT

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

Re: sort help

Joseph T. Wyckoff — Tue, 17 Aug 2004 18:49:14 GMT

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.