Results 1 to 10 of 10

Issue with Solver

Threaded View

realdpg Issue with Solver 02-14-2014, 10:13 AM
newdoverman Re: Issue with Solver 02-14-2014, 04:50 PM
martindwilson Re: Issue with Solver 02-14-2014, 05:43 PM
Jacc Re: Issue with Solver 02-14-2014, 05:54 PM
martindwilson Re: Issue with Solver 02-14-2014, 05:58 PM
newdoverman Re: Issue with Solver 02-14-2014, 06:02 PM
Alf Re: Issue with Solver 02-15-2014, 04:21 AM
realdpg Re: Issue with Solver 02-17-2014, 04:19 AM
newdoverman Re: Issue with Solver 02-17-2014, 10:24 AM
Alf Re: Issue with Solver 02-26-2014, 09:34 AM
  1. #1
    Registered User
    Join Date
    02-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Issue with Solver

    Dear all,

    I will try to describe the issue that i have with Solver:

    I have random amounts in 2 scenarios and I am trying to find a particular target amount, which is a sum of count (x) of amounts from 2 lists – with 16 and 24 amounts

    Now, the solver is working just fine with the 16 amounts, but when trying with 24 amounts, it is not able to find the particular amount I am looking for, but is finding a slightly different result with tolerance and I am searching for this very amount. I am using GRG Nonlinear method without automatic scaling. The variable cell is SUMPRODUCT function of 2 arrays, the first one with the amounts, the other one is "0"

    attached is the file with both scenarios

    Any help will be greatly appreciated and hope I have explained myself well.
    thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Having an issue with Solver
    By jrgraha in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-11-2013, 04:51 PM
  2. please help me out with this SOLVER issue
    By reiswaffeln in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2013, 06:24 AM
  3. VBA issue with Solver
    By saxa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2010, 02:14 PM
  4. Solver Issue
    By dashingdude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2008, 10:28 AM
  5. Solver issue
    By JimGrange in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2008, 11:40 AM

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