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.
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.
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
Such a great video! You helped me with a challenge I thought would be extremely hard to solve. Thank you!
You've just saved me hours trying to solve an impossible equation, thank you!
Works brilliantly. How can I tweak it to make it a group of numbers that can get be closest to target range.
Try setting the solver to an objective or a number (the difference) that is close to zero instead of exactly zero in the model .
This was immensely helpful. Thank you.
This saved me WEEKS! Thank you!!!
This amazingly useful for me. But here comes another problem, what if I want to solve this problem with more than 200 variable ?
Wow, this is amazing!
Thank you so much this is life saver
Thank you this was very helpful
Thank you soo much!
Very smart, thanks.
can you show same method for the reconciliation of a ledger
Many thanks man , it worked .
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.
Thank you!!!
What to do when the number of rows are above 250?
That should still work if there are numbers in that range that can sum up to the given value
what if you have negative values that need to added in column C? will it still calculate the combinations?
if the target value is more than one, how to find sets of numbers from a list
What if it says there are too many variable cells?
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.
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