1. 

   svs9j
   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!

   Posted 1 month ago #

RSS feed for this topic

Reply

You must log in to post.