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


B

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top