Identify numbers that sum up to a target value (Solver)

[@yukunjenniferzhang6637]

Such a great video! You helped me with a challenge I thought would be extremely hard to solve. Thank you!

[@SheridanWhiteside]

Works brilliantly. How can I tweak it to make it a group of numbers that can get be closest to target range.

[@FinexSkillsHub]

Try setting the solver to an objective or a number (the difference) that is close to zero instead of exactly zero in the model .

[@ra52noon]

This was immensely helpful. Thank you.

[@nikkihawkins84]

You've just saved me hours trying to solve an impossible equation, thank you!

[@crystalzeyer4273]

This saved me WEEKS! Thank you!!!

[@vinodjames2007]

Thank you so much this is life saver

[@louislow9921]

This amazingly useful for me. But here comes another problem, what if I want to solve this problem with more than 200 variable ?

[@ernestaboagye3385]

Wow, this is amazing!

[@sharonj7613]

Thank you this was very helpful

[@mkeenan67]

Very smart, thanks.

[@jacquelinedelao1311]

THANK YOU!!!!

[@vinodjames2007]

can you show same method for the reconciliation of a ledger

[@diyamary2561]

Thank you soo much!

[@hydronation]

what if you have negative values that need to added in column C? will it still calculate the combinations?

[@joshuasackey5059]

Can you provide a way to use Solver to determine the number of different currency denominations that sum up to a given amount? For example: How many of these cedi notes - 200, 100, 50, 20, 10, and 5 together make GHC 17,437.

[@chigozie123]

You can do it with some math: 17437 / 200 = 87 rem 37 37 / 20 = 1 rem 17 17 / 5 = 3 rem 2 The answer is you will need 87 of the 200, 1 of the 20, and 3 of the 5. You will then have 2 GHC unaccounted for

[@venkataraopelamala]

if the target value is more than one, how to find sets of numbers from a list

[@MushtaqAhmed-v7b]

Thanks For Good Work I Have Following Multiple Entries In Single Cell Of Excel Sheet. I Want Them To Add Up/Sum Up In Single Cell Without Splitting Entries Into Multiple CellS.??? Entry Format Cell "B20" has Rs30, Rs60, Rs 543, rs30, R 453, Rs9000, Rs9999, Rs3218, ANS "C20" Looking For Auto Sum Formula????? PLEASE HELP.

[@Austin_B626]

Thank you!!!

[@vishwakarmacvishwambhar9124]

What to do when the number of rows are above 250?

[@FinexSkillsHub]

That should still work if there are numbers in that range that can sum up to the given value

[@tamikaleta1626]

What if it says there are too many variable cells?

[@feldertam3463]

Hi, I am using Ms Access for accounting, may I do such solution in Access, VBA or Queries?

[@FinexSkillsHub]

Not sure about Access but maybe VBA

[@call-me-potato.]

Many thanks man , it worked .