This worked absolutely perfectly! I had several numbers, with decimals, ranging small to large. It did take about 3 minutes for the function to run and at one point it seemed like it might crash. But I left it alone and it gave the correct results. Thank you for the clear and concise tutorial!
How do you find an approximation rather than an exact? I have data where no solutions are found because it tries to find an EXACT match. I want it to find a list closest to the value +/- 3
suppose in an excell sheet we have 5 or 6 or more quantity and for a particluar qauntity there is a rate in 2 decimal and now we want to reduce the rate by 10% below and get a particular amount. But unable to achieve due to certain diference in decimal since we have to quote the rates in 2 decimal only. is there any formula for the same. pl suggest
Thank you sir for this! It truly helped a lot! But, what happens if I have more than 1 entry of the same number? Will solver give more than 1 solution/combination? I tried that experiment but it still gave only 1 solution whereas atleast 2 more solutions were visible. Is there a work-around this?
I'm thinking you could add a cell with the (absolute) Difference between Expected value and the sumproduct Formula. Then set the "Objective" to this Difference cell and "To: Min"
First of all thanks for this toturial but i have query about this i got an error while using this formula and that is "Too many Variable Cells. Please suggest me what should i do?
Hi i had a question i need to choose the best combination of value. each value is worth from 1 to 8 and i need to find the best combo by selecting 12 of them that the total equals 30 example i have name from A to Z and each names has a price tag that varies from 20 to 100 and let say that from 20 to 35 the value is 1 from 35 to 45 the value is 2 from 45 to 55 the value is 3 from 55 to 65 the value is 4 from 65 to 75 the value is 5 from 75 to 85 the value is 6 from 85 to 95 the value is 7 from 95 and up the value is 8. my total value has to be 30 and i need to select 12. how to i manage to have the best combination to get the highest price tag combo. hope this is clear
Thank you for the tutorial! I want to ask, what will happen if there is more than one combination? which combination the "solver" will show me? thank you!
generall in work o jobs the numbers have decimals so you are going to have only one posible match and it will work... maby thats no a real problem in real practice.
Bro you have any idea how to program lottory generator consist of six numbers a group each individual number input selected number one or more and rest are same numbers same set and generated possible combination but no repeated numbers must not appear in a group.
Hi If go to excel > FORMULAS > MATH AND TRIG > COMBIN (not combina) > Number is 50......number chosen is 3....i get an answer 19600..........in the cell itself i get text =combin (50,3) question how can i get excell to list all 19600 combin down a column. regards Jim
This worked absolutely perfectly! I had several numbers, with decimals, ranging small to large. It did take about 3 minutes for the function to run and at one point it seemed like it might crash. But I left it alone and it gave the correct results. Thank you for the clear and concise tutorial!
There cant be any better way of Demonstration. Great Great Great Sir
Amazing! i didn't even know such function existed. thank you for helping!!
this was a FANTASTIC tutorial. Exactly what I was looking for, and you explained it perfectly. Thanks again!!
THUMBS UP VERY HELPFUL!!!!! WORKS 100%
10/10 Thanks! this was EXACTLY what I needed
Genius - Well explained video
Thank you! This helped me today! Feb 11, 2021 😊
Superb
Life saver. Thank you 😊
Good thing
I was looking for it many long time. Thanks very much
You're the best.
This helped me in April 2020! Thank you so very much.
Thank you so much for this!!! It works for real and it helps my works. Thank you!
This just saved me hours!!!!! THANK YOU!!!!
What to do if excel says too many variable??
Great job. This is a huge time saver!
very useful for me
Absolutely brilliant! Thank you
This is exactly what I needed! Thanks!
Thank you!! It helped me a lot today! ;)
Very good way to find my error
Hey Thanks man.. so easily explained.. lol using it in 2020
Thanks for your help 😊.
Thanks for the way
Very useful. Thank you!
How do you find an approximation rather than an exact? I have data where no solutions are found because it tries to find an EXACT match. I want it to find a list closest to the value +/- 3
Brillinat! Thanks a lot
Thanks a lot. Was just exploring solution and found.
suppose in an excell sheet we have 5 or 6 or more quantity and for a particluar qauntity there is a rate in 2 decimal and now we want to reduce the rate by 10% below and get a particular amount. But unable to achieve due to certain diference in decimal since we have to quote the rates in 2 decimal only. is there any formula for the same. pl suggest
Thank you! It's very helpful.
Thank you sir for this! It truly helped a lot!
But, what happens if I have more than 1 entry of the same number? Will solver give more than 1 solution/combination? I tried that experiment but it still gave only 1 solution whereas atleast 2 more solutions were visible. Is there a work-around this?
Life saver
Very useful
Thank you so much
Instead of an exact match, is it possible to get the correct combination of values within a tolerance limit of the Enter Value?
Thank you very much!!!! You helped me a lot!
Can solver help me get to the NEAREST desired sum, if the desired exact sum cannot be achieved?
I'm thinking you could add a cell with the (absolute) Difference between Expected value and the sumproduct Formula.
Then set the "Objective" to this Difference cell and "To: Min"
That showed 1 way to get to 178 but what if there are multiple ways to get to 178? How can you see all possible combinations?
That's what I am waiting for..
thank you so much! you just saved my life! ;-)
Life saver! Thank you!
But solver won't be able to give all the possible combination to produce the desired product (i.e. 174 in this case)
First of all thanks for this toturial but i have query about this i got an error while using this formula and that is "Too many Variable Cells. Please suggest me what should i do?
Hi i had a question i need to choose the best combination of value. each value is worth from 1 to 8 and i need to find the best combo by selecting 12 of them that the total equals 30 example i have name from A to Z and each names has a price tag that varies from 20 to 100 and let say that from 20 to 35 the value is 1 from 35 to 45 the value is 2 from 45 to 55 the value is 3 from 55 to 65 the value is 4 from 65 to 75 the value is 5 from 75 to 85 the value is 6 from 85 to 95 the value is 7 from 95 and up the value is 8. my total value has to be 30 and i need to select 12. how to i manage to have the best combination to get the highest price tag combo. hope this is clear
Thank you for the tutorial!
I want to ask, what will happen if there is more than one combination?
which combination the "solver" will show me?
thank you!
+Amit Sassy I've read elsewhere that Solver will only display one solution. I came here with the hopes of getting that same question answered.
generall in work o jobs the numbers have decimals so you are going to have only one posible match and it will work... maby thats no a real problem in real practice.
Can you do for consecutive number ...I have 31 numbers and I want one sum amount ...but I need form consecutive number for those 31 numbers...
What can i do if I have 1000 lines and it shows error that too many variables are there
Did you get any response on it?
Bro you have any idea how to program lottory generator consist of six numbers a group each individual number input selected number one or more and rest are same numbers same set and generated possible combination but no repeated numbers must not appear in a group.
Thanks for the info. How many variables can you use? I want to use over 200 and it says it's too many. Thoughts on how to use?
I am getting the same error. Do you get any solution of it?
Hi
If go to excel > FORMULAS > MATH AND TRIG > COMBIN (not combina) > Number is 50......number chosen is 3....i get an answer 19600..........in the cell itself i get text =combin (50,3)
question how can i get excell to list all 19600 combin down a column.
regards Jim
What if I want the value to be 0
File not found solver 32.dll 😭
Same thing, wtf
there is no solver in my excel
It doesn't give me any solution, Im desperate...