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!
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?
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?
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.
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
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"
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
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
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
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.
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
this was a FANTASTIC tutorial. Exactly what I was looking for, and you explained it perfectly. Thanks again!!
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?
10/10 Thanks! this was EXACTLY what I needed
THUMBS UP VERY HELPFUL!!!!! WORKS 100%
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?
Life saver. Thank you 😊
I was looking for it many long time. Thanks very much
Thank you! This helped me today! Feb 11, 2021 😊
What to do if excel says too many variable??
This is exactly what I needed! Thanks!
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.
Thank you so much for this!!! It works for real and it helps my works. Thank you!
Genius - Well explained video
This helped me in April 2020! Thank you so very much.
Absolutely brilliant! Thank you
This just saved me hours!!!!! THANK YOU!!!!
Great job. This is a huge time saver!
Thank you!! It helped me a lot today! ;)
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..
Good thing
Instead of an exact match, is it possible to get the correct combination of values within a tolerance limit of the Enter Value?
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
Thanks a lot. Was just exploring solution and found.
Hey Thanks man.. so easily explained.. lol using it in 2020
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"
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?
Superb
You're the best.
Thank you so much
Brillinat! Thanks a lot
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...
Very good way to find my error
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
Very useful. Thank you!
Thank you! It's very helpful.
Thanks for your help 😊.
Thank you very much!!!! You helped me a lot!
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
very useful for me
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
Thanks for the way
Very useful
Life saver
Life saver! Thank you!
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.
thank you so much! you just saved my life! ;-)
But solver won't be able to give all the possible combination to produce the desired product (i.e. 174 in this case)
What if I want the value to be 0
File not found solver 32.dll 😭
Same thing, wtf
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?
there is no solver in my excel
It doesn't give me any solution, Im desperate...