• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Permutations/Combinations

S

svs9j

New Member
Hi,


I have a sequence of 6 ads that


Brand ads (B): A, B, C

Product ads (P): D, E, F


I am trying to work out an sequence like BBBPPP using each ad from the B and P categories and have all combinations, maintaining the BBBPPP order.


Example:


ABC DEF

CBA DEF

BCA DEF

----

----

----


Is there a way I can do this in Excel? I have been trying to play around with the PERMUT and COMBIN functions with no luck. I want it to output the actual sequence and not the # of iterations possible.


Any help is appreciated.


Thanks!
 
You must log in or register to reply here.
Back
Top