JESUS! This has changed my life. I can't tell you how many hours of my life has been wasted trying to manually reconcile individual details to a larger total. This feature has been sitting under my nose this whole time. Game changer!
Oh my god, amazing, thank you so much, you just saved me so much tile and effort, perfectly explain, short and accurate, thanks for not making a 15 minutes video 💎❤️❤️👏👏
how about in your example 134, finding sum of two or more numbers to the closest specified total number which is 134 for example but not lower than let say 125. how to?
Didn't really help in my case, because I have a long list (70+) of Variables that need to be matched to a set value. Solver can't handle this unfortunately.
Thank you for the video - very easy and interesting. But I wanted to test with another number and got a problem. If instead of 134 I look for numbers which provide me 36, Excel choses A10& A11 (23+13) but doesn't see A7&A8 (12+24). how can we deal with several possibilities?
JESUS! This has changed my life. I can't tell you how many hours of my life has been wasted trying to manually reconcile individual details to a larger total. This feature has been sitting under my nose this whole time. Game changer!
Totally today I was just facing the same issue
Literally this work thanks for this Excel trick. Though it took some time on a bigger data but I was able to track the combination ❤ you rock girl 🎉
It's awesome, it's solved lots of my work
Many Thanks its very Helpful
Oh my god, amazing, thank you so much, you just saved me so much tile and effort, perfectly explain, short and accurate, thanks for not making a 15 minutes video 💎❤️❤️👏👏
Great video! This is a life saver. Thank you so much
Thanks this is a life saver for me .
You literally made our job easier! Thank you!!
Thanks for your information
Wonderful! you made my day
Thank you Madam, Simply Explained, Great Work
Informative. But What if there are more than 1 set of numbers adding to the same value?
I would never discover this by myself.. Many many thanks!!!
Thank you for the help helped me a lot
Thank you for the video , if I want to find the sum between 134 to 150 is it possible
Excellent I m very happy now I got it what I need...thank you very very very very much😍😍😘😘😘😍😍🤩🤩
Great job!!! This helped me so much!!! ❤
how about in your example 134, finding sum of two or more numbers to the closest specified total number which is 134 for example but not lower than let say 125. how to?
Great Work, i have got what i needed.. Thanks a Million :)
Thank you. It helps me a lot.
Didn't really help in my case, because I have a long list (70+) of Variables that need to be matched to a set value. Solver can't handle this unfortunately.
same issue i have, found any solution ?
Can we do the same in python,?
Thank you, very useful.
What if the value of every data is big? My excel got freeze everytime do this
Thank you so much 💙
Thank you for the video - very easy and interesting. But I wanted to test with another number and got a problem. If instead of 134 I look for numbers which provide me 36, Excel choses A10& A11 (23+13) but doesn't see A7&A8 (12+24). how can we deal with several possibilities?
Unfortunately no answer.
I got more confused watching this video 👀💀😵 but very informative
Thank you madam 🖤🖤🖤
Thank you 👍
Lifesaver
Great Work! Thanks
Thank you so much
I want 300 divide 15 part randomly