Generating permutations on three factors

[alithebarman]

Afternoon all.

I attempting to generate a list of possible permutations based on 3 possible factors (one factor of 227 possibilities, a second factor or 8 possibilities and a final factor of 25 possibilities). The combinations are starting to blow my mind a little.

As a brief example I'm starting with:

<table border="1">
  <tr>
    <td>Stream</td>
    <td>Level</td>
    <td>Instance</td>
  </tr>
  <tr>
    <td>BSBADM</td>
    <td>1</td>
    <td>01</td>
  </tr>
  <tr>
    <td> </td>
    <td>2</td>
    <td>02</td>
  </tr>
</table>

I would expect the result to be the following list:

• BSBADM101
• BSBADM102
• BSBADM201
• BSBADM202

If at all possible it would be very useful to update the formulas to the list of permutations changes.

Appreciate any and all comments guys!

 

[gregtx81]

See http://www.mrexcel.com/forum/showthread.php?t=581760

 

[alithebarman]

That's excellent, did exactly what I wanted it to.

THANKS!