Permunitations.. Anyone have an worksheet function to expand a list of numbers into all unique patt

[BilReese]

Hi,
If I had a series of numbers like this, each in a separate cell
(horrizontal)

1 2 3 4 5

What formula can I paste into a 5 column grid below it to fill in all the
patterns possible like this (this is not complete)

1 2 3 5 4
1 2 4 3 5
1 3 4 5 2
1 3 4 2 5
1 4 2 3 5
1 4 2 5 3
2 1 3 4 5
2 3 5 4 1
2 4 5 3 1
2 4 1 5 3
2 5 3 4 1
2 5 3 1 4
2 5 1 4 3
3 1 5 2 4
3 2 5 1 4
4 2 3 5 1
3 4 5 2 1
3 4 2 1 5
3 5 4 1 2
3 5 2 4 1
3 5 1 4 2
3 5 4 2 1
4 1 3 2 5
4 1 2 3 5
4 2 3 5 1
4 3 2 1 5
4 5 1 3 2
5 1 3 2 4
5 1 2 4 3
5 3 4 1 2
5 3 2 4 1

 

[Harlan Grove]

If I had a series of numbers like this, each in a separate cell
(horrizontal)

1 2 3 4 5

What formula can I paste into a 5 column grid below it to fill in all the
patterns possible like this (this is not complete)

...

Try a Google Groups search.

http://www.google.com/groups?as_q=permutation&as_ugroup=*excel*&lr=lang_en

though the following may come closest.

http://www.google.com/[email protected]