Generating table of permutations of text values

[bernborough]

Hello,

I don’t think a Pivot Table is going to accommodate the number of permutations I am looking to have displayed. Couldn’t find a text related function that would display these combinations for me. I hope someone can help.

Scenario:
There are 10 possible values for data contained in Columns A to F (Header title of each column is 1st, 2nd, 3rd.....6th). The 10 possible values are: “Break”, “Down/Even”, “Down/Under”, ”Down/Over”, “Same/Even”, “Same/Under”, “Same/Over”, “Up/Even”, “Up/Under”, “Up/Over” AND :
(i) “Break” can only be present in one of the 6 columns or not at all; and
(ii) All other values can be duplicated any number of times across any of the columns.

how can I produce a table in which each row displays each possible permutation of those values for 1st through 6th according to those two rules?

Thanks

Trent

[stanleydgromjr]

bernborough,

This may get you started in the right direction.

If you copy the information in the title row, except for “Break”, and transpose them into a new worksheet in column A.

Then in cell B1 type in 6 (or some other number), and run this macro:
Create list of all pair combinations
By pgc01
http://www.mrexcel.com/forum/showthread.php?t=412952

[bernborough]

Thanks alot Stanley. This has brought me further towards a solution.

One aspect that I would like to accommodate is to have the macro By pgc01
http://www.mrexcel.com/forum/showthread.php?t=412952 accommodate the presence of duplicate entries of an element.

So, for example, a row of data From columns C to G has the values:
Same/Under, Same/Even, Up/Over, Up/Even, Break, Same/Even
Here, "Same/Even" is duplicated.

Is there something simple that can be changed within the macro By pgc01
http://www.mrexcel.com/forum/showthread.php?t=412952 to allow these types of datasets(rows) to show up in the table ??

The permutations would be massive I know.

Thanks,

Trent

[bernborough]

One aspect that I would like to accommodate is to have the macro By pgc01
http://www.mrexcel.com/forum/showthread.php?t=412952 accommodate the presence of duplicate entries of an element.

So, for example, a row of data From columns C to G has the values:
Same/Under, Same/Even, Up/Over, Up/Even, Break, Same/Even
Here, "Same/Even" is duplicated.

Can this be done? The permutations would be massive I know.

Thanks,

Trent

[shg]

There are 885,735 permutations. What would you do with them after you had them all listed that you couldn't do without listing them?