I am trying to find a way to do the following:
I have a list of x numbers (lets say 100 numbers)
I know that 2 of the numbers in the list add up to y (lets say 255.21)
Is there a way in Excel to find which two specific values add up to that value? (In the hypothetical above, it may find 2 values that are 130 and 125.21)
Finally (and only if the above can be accomplished), how would the procedure change if you had to combine 3, 4, or z numbers to reach the specific value?
Many thanks for any tips you can offer!!
Bookmarks