title: Excel Solver Finding a Target Sum from Subset of Number Set
body: <p>I want to use Solver to find a target sum from a subset of a larger set. (10 number subset of 16 numbers). I'm not very familiar with Solver and I'm unsure of the best way to set my constraints. </p>
  
  <p>I have 5 categories of numbers within the set, A, B, C, D, E. The set of 16 may include different combinations of these categories, but the target subset total has a defined makeup: 
  A, B, B, C, C, C, (B or C), (B or C),D, E</p>
  
  <p>So my question is, how would I introduce these rules into Solver?</p>
  
  <p>Secondarily, I know Solver comes up with 1 solution, is there a way to get a range of solutions that are closest to the target? So, if I have a set that doesn't quite produce the target, I could see 3 solutions that are nearest the target (plus or minus)?</p>
  
  <p>Thanks.</p>