+ Reply to Thread
Results 1 to 1 of 1

Identifying all combinations adding to a number and showing labels for those combinations

  1. #1
    Registered User
    Join Date
    12-21-2020
    Location
    Virginia, US
    MS-Off Ver
    365
    Posts
    8

    Identifying all combinations adding to a number and showing labels for those combinations

    Hello. Any help on this challenge would be greatly appreciated:
    I have a file (attached on this thread) that has labels in column A, and then a corresponding value in column b.
    On different days, the file could have less or more rows filled in a and b.
    I need to find all the possible combinations of 3 label/value combinations where the values add to exactly 7.
    In the file attached, I have done this manually two different ways. In column D, i have concantenated the 3 labels (and put a ";" between each label). In Columns G through L, i have put the Labels and value combinations in the same row.
    Is there a way to populate either column D and/or G through L via VBA code or some combination of formulas? Populated D AND G through L would be great, but if one (D OR G through L) is easier than the other, that's fine too.
    A couple items:
    -The values will always be 5, 4, 3, 2 and 1.
    -Three values must always be used (so for example a 5 and a 2 add to 7, but this combo is not acceptable. There must be three).
    -The sum of the three values must equal exactly 7 (so for example, three separate 2s are obviously three values, but they don't add to 7 so that combo is not acceptable).

    Hopefully the description above and file attached is clear. Happy to provide other details if needed. Thanks!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Identifying Combinations
    By Balzer13 in forum Excel General
    Replies: 4
    Last Post: 06-02-2020, 12:07 PM
  2. [SOLVED] Showing all combinations of a set of numbers
    By chris2005 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-25-2019, 12:29 PM
  3. [SOLVED] Complex VLOOKUP - Identifying values used in different spreadsheet - combinations :)
    By s_bruno1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-09-2015, 12:35 PM
  4. Replies: 3
    Last Post: 12-09-2015, 09:34 AM
  5. Identifying multiple value combinations
    By vicentiu in forum Excel General
    Replies: 0
    Last Post: 07-26-2013, 07:05 AM
  6. Replies: 0
    Last Post: 08-23-2012, 12:36 PM
  7. Finding possible combinations & listing the wanted combinations
    By Zoke in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-16-2012, 03:41 PM

Tags for this Thread

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