Searching a range of numbers for a specified total

Tech-Archive recommends: Fix windows errors by optimizing your registry

I know that Excel has a way to search a range of numbers and try all
possible combinations in that range to see if any of the numbers in the
range equal a specified total. For example (a very simple example),
column A, with the numbers 102, 209, 315, 483 and 562. How do we get
Excel to search column A for the combination of cells that would equal
524?

I also know this requires solver, but am unsure of how to manipulate
solver to perform this task. Any tips would be greatly appreciated.

.

Relevant Pages

  • Re: Calculation Operator ">" not ">=" !!
    ... built-in comparison operators to choose from: ... (choosing the constraint A>= B appears to force the built-in ... It's MS Excel 2003 add-in Solver module. ...
    (sci.math.num-analysis)
  • Re: Solver problem
    ... For example, Excel 2007's example prices are 35,50,75, but this problem uses ... This will often cause an error with Excel's Solver. ... speaker cones, power supplies, electronics, laser ... The sales price per item is reduced by 5% for orders of 100 or more and ...
    (microsoft.public.excel.worksheet.functions)
  • RE: How to run Solver from Visual Basic?
    ... "Tom Ogilvy" wrote: ... Here is some sample Excel code to add the solver addin and crate a reference ...
    (microsoft.public.excel.programming)
  • Re: solver.xla problems migrating from Excel97 to 2003
    ... I meant that the new code works with a reference. ... whether I put a reference to SOLVER in tools>RErefences.. ... A new Installation of Excel ... script that would load the Solver add-in on networked units using Excel. ...
    (microsoft.public.excel.programming)
  • solution to solvers error.
    ... open the solver give the input(tgt. ... 5.Click "OK" (don't open the answer,sensitivity or limit report). ... Excel 2007 Solver Internal Error When Generating Answer Report ...
    (microsoft.public.excel.misc)