Hello,
I wonder if you could help me. (I'm using Excel 2007 on a Vista machine for reference).
I have been given a value, which is the output.
I have a list of 44 possible inputs.
Is there a way where it shows me the combination of the sum of inputs (from the list of 44 inputs) that derive the given output? The values are quite unique, so there will only be one combination (if one at all).
Is this possible? Or how can I do it without trial and error?
Thank you
I wonder if you could help me. (I'm using Excel 2007 on a Vista machine for reference).
I have been given a value, which is the output.
I have a list of 44 possible inputs.
Is there a way where it shows me the combination of the sum of inputs (from the list of 44 inputs) that derive the given output? The values are quite unique, so there will only be one combination (if one at all).
Is this possible? Or how can I do it without trial and error?
Thank you