Right this is a bit hard for me to communicate but I will try my best
I want to be able to find what numbers in a list of numbers will add up to give me a certain value. For example:
I have a list as below
1.0
2.1
3.0
4.1
5.1
6.5
I want to find out what numbers I will have to add to get 11.3 Now I know that it would be 2.1, 4.1 and 5.1 but is there a program or a way in excel in which the computer will tell me this. Note: I want to do this with more complex lists not just this example.
It would also be good if it could tell me the answer if there were more than 1 way to do it. And it would also be good if I can put a list of values to find the answer to. These two points are good to know but not needed
Social Networking Bookmarks