Suppose I have something like:
A1 = 500
A2 = 650
A3 = 725
A4 = 18
A5 = 1000
A10 = 1518
A10 is the sum of A1+A4+A5. How would I get Excel to tell me what combination of numbers in a particular range equal a known value?
Suppose I have something like:
A1 = 500
A2 = 650
A3 = 725
A4 = 18
A5 = 1000
A10 = 1518
A10 is the sum of A1+A4+A5. How would I get Excel to tell me what combination of numbers in a particular range equal a known value?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks