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