+ Reply to Thread
Results 1 to 1 of 1

Routine to an specific type of combination

  1. #1
    Registered User
    Join Date
    01-19-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    26

    Routine to an specific type of combination

    Hi guys, I'm having problems building an routine to solve this thing:

    I need to run combinations of the 5 values below (a,b,c,d,e) and check if the sum of the combinations matches with one of the 3 results (v1,v2,v3).

    Please Login or Register  to view this content.
    If positive, the combined values would be associated with the result value, like:

    Please Login or Register  to view this content.
    In the end, It would build an array like this
    Please Login or Register  to view this content.
    As you can see, it doesn't matter the order of the values, since I'll sum them all together. Also, the results could be the sum of every value, as it could be a single value.

    The example I used is real, and it is a short one, with only 5 values, there are cases with over 30 values, and more then 3000 cases, so, doing it manually is not an option.

    The real problem is with the combination routine, the rest of it is not a problem.

    ------------ EDIT ------------
    By the way, right now, I'm trying to make it work like a binary progression:
    Please Login or Register  to view this content.
    Just figuring out how to make it happen...

    ------------ EDIT ------------
    Thanks in advance for your attention.
    Last edited by bagulhodoido; 07-10-2012 at 09:34 PM.

+ 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