How to Identify Numbers that Add Up to a Specific Value using Solver Add-in of Excel
Вставка
- Опубліковано 25 сер 2024
- This video explains you, how you can Identify certain numbers that add up to a specific value using Solver Add-in of Excel. This video offers the solution to everyday challenge for the people who works as an auditor, accountants etc. Solver can be used also to find solution for many problems like - optimum scheduling of machineries in a workshop, allocation of employee shift, Optimizing the delivery route etc. #excel, #solver .
You can find other video on solver at • Solution to Puzzle usi...
Found a video that gave this solution right before and it did a great job giving step by step instructions that can actually be followed.
However, how you presented this video made me literally understand how it works by demonstrating piece by piece how one change to an option affects the result and that is a major difference in level of functioning, flexibility and comfort in utilizing a resource. As a former teacher of a different field, sir, you have achieved teacher level 500!
This was a lifesaver! I was going to have to try and manually match up numbers to try and get to the totals I needed. Thank you for posting.
Thank you
Oh man you absolute boss. Thank you so much. I work in finance and need to analyse different line items across multiple purchase orders to match my total asset value.
I was working across hundreds of lines of costs and this has helped so much and now my boss thinks I’m a genius 😂
Thank you
Excellent presentation!
Thank you very much , finally solved 1 of hardest report today
Thank you
You're the best, Wilson!
Thank you
You are greate
You have explained it so well. I heard all foreigners video on same topic they were so confusing. You covered everything. You are awesome
Thank you
This is what I am looking for. Thanks.
Thank you
This helped me. Thank you so much!
Glad it helped!
Amazing video. Thank you so much ❤️
Thank you
many Thank Sir Very Helpful and useful
Thank you
Perfect explanation. Thank you!
Thank you
Great! Most useful!
Glad it was helpful!
Thanks 🙏
Is there a way to see other different possible solutions?
THank you very much sir🙏🙏🙏🙏🙏
Thank you
Awesome Mr. Wislon, today I was using this but while solving large values it is taking more time.
Thanks for the comments Raza, you are right, sometimes it takes long to solve, you may have to look at ways to simply calculation if any and also reduce constraints if not needed
Thank you so much Sir
Thank you
can it show the more than one combonation
Each run may show different answers if more combinations are available. You may give restrictions to narrow down the answers. But at a time only one result only can be seen
Hello Sir, suppose you have a value 12 and you have to divide the value in 1 into 12 times, and highlight it, in a column, just like a bar graph, please gave some bit idea
Couldn't understand, sorry, Can you please elaborate?
What happens if there’s more than one possible solution? What does solver do when it encounters that situation?
yeah I am wondering the same, did you find any solution for that?
If you have 5 cells each one of them value of 2 ... how u get all potential cells that sum of them equal to 8 ??? Using solver please advise
What happens if there are more than one possible solution? How do I see the other possible solutions?
Will it work if we have values in positive and negative?
Yes, it works
Awesome video 💕 This is what I'm looking for.
Btw, what is the maximum no. of cells in a column for that?
Does it take a long time for excel to solve? My excel is spinning for over 10 mins.
what if there are more than one combination?
Each run may give different if there are multiple answers
What about duplicate numbers?
We don't have any control over which one it selects, same setup if we run again, it may give a different solution altogether if available. For the duplicate numbers, if you want to exclude completely, you may do it by adding an helper column with an if condition.
I'm mirroring everything you do, but I'm still getting decimals
Add an integer restriction
not working in decimal figures 😢
It works decimals as well, I have done it many times. Or if you can provide me more details, i can try it.
This is what I'm looking for 10Q
Thank you
Yes, but what if there is a column with 15,000 entries. It won't do it
I think it will work.
It works, but depending on the complexity it may take some time, so put an iteration limit before running
@@My.account916 I tried and it computes for 30 mins and then freezes.
Not working if there are too many variable cells 😭😭😭
Sir, if values with decimals how can we do?
Give me the data or problem statement, I can suggest you the solution
Runned into run time error, what does it mean?
There will be an error number alog with the message, Either you can send me that or Google that error number to know the reason for the error
With large datasets, it takes a very very long time. Algorithm is not very smart.
Yes, you are rite, if possible we should optimise the data before applying
Non
What if your column A contains number that doesn't amount to 52?
It will show as solution not found. To control the time it takes, you may consider entering the maximum time in the options window of the solver.
Completely useless application. You are limited in your search data to 200 values. What kind of accountant works with a data set of less than 200 numbers?
somebody that is not an accountant...
If you have 5 cells each one of them value of 2 ... how u get all potential cells that sum of them equal to 8 ??? Using solver please advise