Find which items sum up to a given amount

The Solver add-in should help but I dont know anything else about it.

Subset sum problems are common. In Excel, one usually uses Solver, though, Solver may not reliably find correct solutions when multiple solutions are possible or as the data set becomes larger.

Previous discussion: https://www.excelforum.com/excel-for...l-to-cell.html
Outside tutorial: http://www.k2e.com/tech-update/tips/...specific-value

How can we help you implement a solution like that?

a possible solver setup could be like this but beware of the problems mentioned by MrShorty

Alf

You are welcome and thanks for feedback.

it works only with up to 200 rows.

Yes, so sad but true. On the other hand there is the freebie "OpenSolver" developed by the University of Auckland N.Z. It integrates nicely with Excel and as long as the problem is a linear one you can use it for your problem which also is a linear one.

You can build your model in Excel as "OpenSolver" can read an Excel solver model and the best of all, according to the website there are no limit to the number of constraint so you can have as many rows as you need. To download see link below:

https://opensolver.org/

it stops when finds first match.

Yes, that is the way solver works but you can try to add some constraint i.e. perhaps setting a min and max number (value) on quantity and amount or specify that one or more of the
F values that in a precious run was 1 should be 0, this will force solver to try and find another solution.

Alf