title: Combinatorics in excel: Find every possible sum of every possible combination
body: <p>Ok, I´ve found similar questions but none of them solve this problem so here I go:</p>
  
  <p>I´ve a list of individuals (col. "A"), and each of them has a value assigned for a determined parameter (col. "B").
  I´ve some target parameter values and I want to know which combinations of individuals sum up "x" for that parameter value.</p>
  
  <p>Let´s take an example:</p>
  
  <pre><code>      Col. A                      Col. B
  
         M                            10
         N                           -5
         O                           -8
         P                            0.87
         Q                            9
  
       - Target for Parameter("X"): 9-10
  
       - Solution:
                  S1= Q+P -&gt; 9.87
                  S2= Q   -&gt; 9
  </code></pre>
  
  <p>As you can see just by inspection, the only ways to do this is taking Q, or Q+P.
  But in my case, I´ve between 10-15 subjects each time, and doing the work by inspection is not easy at all. </p>
  
  <p>I would want to generate a chart with all the possible values (being able to know which subjects are generating the value), or just a way to know the "y" closest combinations.</p>