Results 1 to 14 of 14

Permutations of a list (groups of 3)

Threaded View

  1. #1
    Registered User
    Join Date
    11-01-2006
    Posts
    18

    Permutations of a list (groups of 3)

    Is there any way to determine all possible unique combinations (or sets) of any 3 strings in a table? I need to make a master set list from a list of strings which could be over 100 elements long.

    Once I have a result set, I need to get rid of any groups which have a value contained in another group.

    Example:
    cells A1 through B100 contain:
    Item1 45
    Item2 50
    Item3 98
    ...
    Item100 75

    Result set would contain groups of any 3 item combinations where the corresponding "B" value is within a certain range (between 40 and 80), while also trying to create sets with the lowest possible sum (placed in the 4th column) of the 3 numbers.

    One possible combination would be:
    Item1 Item2 Item100 170

    etc...

    I need to list all possible combinations, without re-using an element from a previous (lower sum) combination that matched the criteria. Any ideas?
    Last edited by xlwho; 08-31-2007 at 06:41 PM.

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