Hi,
I'm not sure if excel is powerful enough for this but I need to find a particular combination of numbers that add up to 188,280 from a table of numbers. I can't do this manually as I tried 5 options, even though it seems like a better option :P
If excel isn't the best thing, I'll need something else.
Last edited by Murellus; 11-14-2010 at 12:43 PM.
Murellus - Welcome to the Board please note however that your original title falls foul of Rule 1 of the Board's RULES
Given this is your first post I have on this occasion modified the title for you.
Regards the question see below for an overview of the issue (and possibly solution pending requirements):
http://www.excelforum.com/tips-and-t...tion-sums.html
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi Murellus,
It looks like there are a few answers. I created a random number generator and let it run until it worked. See code and formulas in the attached.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Wow, I'm glad I didn't read DonkeyOte answerthat pointed to shg answer
that made this problem sound hard.
I would have never tried a random number generator if I thought there was no answer.
Thanks for the responses. Ok I see why this is tough now. I've tried to copy the data that I have into the template (I really don't know VBA) and I'm getting a 'This isn't a linear problem' from Solver and I'm not sure why? (When I use solver I just typically look for any division signs but I can't see any).
I've attached my modified template. If anyone can help tell me why I'm getting a linear error problem with Solver, that would be great!
here its done with solver
adjusted the tolerances a bit and also added constraint of integer as well as binary as for some strange reason the binary constraint doesn't always hold true
Last edited by martindwilson; 11-14-2010 at 06:32 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Tyvm! I'm also just wondering what values you put in for the Load Model input in Options in Solver?
Load Model input ?
see screen shots in attached
Last edited by martindwilson; 11-14-2010 at 08:03 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks