Combination for Targer Value

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

@HiumanSqrib 

 

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

 

Nikolino

 

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.

Nikolino
I know I don't know anything (Socrates)