+ Reply to Thread
Results 1 to 1 of 1

Permutations and combinations

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Accra,Ghana
    MS-Off Ver
    Excel 2010
    Posts
    3

    Unhappy Permutations and combinations

    Hello Members am new to this Forum and i signed on to the forum to help users, but i have encountered a problem myself. I have been trying to combine some numbers and their occurrences but i can't figure it out entirely, it is getting out of control and mind blogging. I need to know how to combine or perm 3 set of numbers with no one order repeating itself but are a total of 14 rows or cells .eg.


    1 2 3 2 1 3 1 3 2
    2 1 3 1 2 3 ...........
    1 3 2 3 2 1 ...........
    3 2 1 2 1 3 ...........
    1 2 3 3 2 1 ...........
    2 3 1 1 3 2 ...........

    ............ and so on for 14 rows but i need each row to be unique in set of numbers so that no one row set is repeated in any block of 3 columns on that same row. no one block of numbers (that is one set of columns and rows should be the same) should be the same. Please can some one tell me how to go about that in excel. Like the formula or any other means to achieve that.
    Last edited by WELLO; 11-28-2012 at 12:02 PM. Reason: inside of the thread there was no formatting/spacing of blocks like when i was writing or typing it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1