How to Identify Numbers that Add Up to a Specific Value using Solver Add-in of Excel

No video

How to Identify Numbers that Add Up to a Specific Value using Solver Add-in of Excel

Рет қаралды 22,795

3 жыл бұрын

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...

Пікірлер: 72

@user-el4dq1ge4p Ай бұрын

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!

@user-yu9nd3sp7d 10 ай бұрын

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.

@wilsonpowlous 6 ай бұрын

Thank you

@lagundafire 11 ай бұрын

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 😂

@wilsonpowlous 6 ай бұрын

Thank you

@user-xb2ej2mb3k 5 ай бұрын

Excellent presentation!

@user-th6vn8me3x 2 жыл бұрын

You have explained it so well. I heard all foreigners video on same topic they were so confusing. You covered everything. You are awesome

@wilsonpowlous Жыл бұрын

Thank you

@Redrung 2 жыл бұрын

Thank you very much , finally solved 1 of hardest report today

@wilsonpowlous Жыл бұрын

Thank you

@bradmilligan6388 7 ай бұрын

You're the best, Wilson!

@wilsonpowlous 6 ай бұрын

Thank you

@mastshorts8648 4 ай бұрын

You are greate

@bankreconciliationinminute9909 2 жыл бұрын

This is what I am looking for. Thanks.

@wilsonpowlous Жыл бұрын

Thank you

@jenniferw5735 Жыл бұрын

This helped me. Thank you so much!

@wilsonpowlous Жыл бұрын

Glad it helped!

@eduardoherrera-gu9pr 11 ай бұрын

Amazing video. Thank you so much ❤️

@wilsonpowlous 6 ай бұрын

Thank you

@GeorgeAJululian Жыл бұрын

many Thank Sir Very Helpful and useful

@wilsonpowlous 6 ай бұрын

Thank you

@My.account916 Жыл бұрын

Thanks 🙏

@MizzC625 Жыл бұрын

Great! Most useful!

@wilsonpowlous Жыл бұрын

Glad it was helpful!

@Rickable Жыл бұрын

Perfect explanation. Thank you!

@wilsonpowlous Жыл бұрын

Thank you

@AitissamRaza 3 жыл бұрын

Awesome Mr. Wislon, today I was using this but while solving large values it is taking more time.

@wilsonpowlous 3 жыл бұрын

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

@DeenaDianna Жыл бұрын

Is there a way to see other different possible solutions?

@SanthoshKumar-xy3zm 2 жыл бұрын

THank you very much sir🙏🙏🙏🙏🙏

@wilsonpowlous Жыл бұрын

Thank you

@vanmido7349 Жыл бұрын

Awesome video 💕 This is what I'm looking for. Btw, what is the maximum no. of cells in a column for that?

@sadequehassan3984 2 жыл бұрын

Thank you so much Sir

@wilsonpowlous Жыл бұрын

Thank you

@brookehunter3304 Жыл бұрын

What happens if there’s more than one possible solution? What does solver do when it encounters that situation?

@saurisco338 Жыл бұрын

yeah I am wondering the same, did you find any solution for that?

@saurisco338 Жыл бұрын

What happens if there are more than one possible solution? How do I see the other possible solutions?

@sndpdhwn 6 ай бұрын

can it show the more than one combonation

@wilsonpowlous 6 ай бұрын

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

@kushalchakraborty5021 11 ай бұрын

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

@wilsonpowlous 6 ай бұрын

Couldn't understand, sorry, Can you please elaborate?

@violetaperales5064 2 жыл бұрын

Does it take a long time for excel to solve? My excel is spinning for over 10 mins.

@coolestrami Жыл бұрын

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

@ganeshbodate772 6 ай бұрын

Will it work if we have values in positive and negative?

@wilsonpowlous 6 ай бұрын

Yes, it works

@AdityaGupta-my7uz Жыл бұрын

what if there are more than one combination?

@wilsonpowlous 6 ай бұрын

Each run may give different if there are multiple answers

@yefenatube644 Жыл бұрын

This is what I'm looking for 10Q

@wilsonpowlous 6 ай бұрын

Thank you

@SURGROX Жыл бұрын

What about duplicate numbers?

@wilsonpowlous Жыл бұрын

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.

@sunilmangla4135 Жыл бұрын

not working in decimal figures 😢

@wilsonpowlous Жыл бұрын

It works decimals as well, I have done it many times. Or if you can provide me more details, i can try it.

@carpeomnia6545 Жыл бұрын

Yes, but what if there is a column with 15,000 entries. It won't do it

@My.account916 Жыл бұрын

I think it will work.

@wilsonpowlous Жыл бұрын

It works, but depending on the complexity it may take some time, so put an iteration limit before running

@carpeomnia6545 Жыл бұрын

@@My.account916 I tried and it computes for 30 mins and then freezes.

@PW580 Жыл бұрын

I'm mirroring everything you do, but I'm still getting decimals

@wilsonpowlous 6 ай бұрын

Add an integer restriction

@satyanarayanatiriveedhi4796 2 жыл бұрын

Sir, if values with decimals how can we do?

@wilsonpowlous 2 жыл бұрын

Give me the data or problem statement, I can suggest you the solution

@ngkhengyean4748 10 ай бұрын

Not working if there are too many variable cells 😭😭😭

@sophiaricaac4613 Жыл бұрын

Runned into run time error, what does it mean?

@wilsonpowlous Жыл бұрын

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

@maxevans2949 2 жыл бұрын

With large datasets, it takes a very very long time. Algorithm is not very smart.

@wilsonpowlous 2 жыл бұрын

Yes, you are rite, if possible we should optimise the data before applying

@sphelontaka4691 Жыл бұрын

Non

@wolfcompany2 Жыл бұрын

What if your column A contains number that doesn't amount to 52?

@wilsonpowlous Жыл бұрын

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.

@thanksforbeingausefulidiot9016 Жыл бұрын

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?

@saurisco338 Жыл бұрын

somebody that is not an accountant...

@coolestrami Жыл бұрын

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