sort but not at random.

tony0217

Board Regular
Joined
Aug 31, 2012
Messages
134
So i have searched for this topic already i promise.
the problem is i have 1 column that goes from a to d.
im trying to develop a way to sort this column in every way and have it post to a new column directly next to it until all possible arrangements have been done.

so im basically rearranging the column and posting it next to the previous one and so on until there are no more possibilities left. using A to E there should be about 5,040 combinations.

How can i accomplish this?
please help thank you.
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,545
Try searching for "permutation" or "combination". This topic has been covered many times.

Using the letters A-E, there are 120 combinations. Using the letters A-G, there are 5040 combinations.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,264
Messages
5,443,406
Members
405,234
Latest member
AA90

This Week's Hot Topics

Top