Combination for Targer Value

New Contributor
Dear Seniors,
Can U suggest any way to find a combination thats sum equal to given Number?? Plz.
4 Replies
I think you are looking for Goal Seek,,, or Solver. Please share some sample data along with expected output, help me and others to fix the issue.



Dear young person

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.


* Knowing the Excel version and operating system would also be an advantage.


Thank you for your understanding and patience




I know I don't know anything (Socrates)

Thanks Boss...
Query Updated... 🥰🥰
Thank you for your understanding

Wish you a nice day / night with lots of health, joy and love.

I know I don't know anything (Socrates)