Is there anyway to use Excel to determine which of a set of numbers equals a total? I encounter this issue when dealing with accounts receivable. We receive payments with no details on what is being paid. I have a list of open items and a total being paid. I would like to have Excel determine which combination of invoices can be added together to match the payment. Not sure if this can be done but thought I would ask. I appreciate any help that can be provided.
Thanks,
DaveBab
Check this post, it came from a few years back but it's a similar problem to what you are having. However, I would think it probably does not help too much if you are dealing with account receivable since you are probably looking at hundreds and thousands of data. Good luck.
http://www.excelforum.com/excel-work...for-a-sum.html
Entia non sunt multiplicanda sine necessitate
Thank you! This is a great feature. I typically have somewhat smaller data sets (~50), so it takes a bit to run, but can be very helpful. One question on the instructions. There is a formula B2:B100=0 in the example. Where would this be used? I couldn't find it in the solver spreadsheet example that was provided.
Thanks,
DaveBab
Last edited by DaveBab; 01-30-2009 at 02:52 PM. Reason: Change of who I was responding to
go to this site: http://www.handyexcelmacros.net
Go to the Sum to target page
Download the excel file.
I wish to delete the above comments now because the website http://www.handyexcelmacros.net will be going down soon. Dredge.
This seems to me to be the same as that placed in the post http://www.excelforum.com/search.php?searchid=4467096
and for which I presented an Excel array formula for a sub-list of 9 elements
Hi
See the file Sample_6.xlsx
Regards
Jose, you are responding to a really old thread, I doubt any members are still following it
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks