M
M Randall
if you have an array of numbers and want to identify
which of those numbers add up to a specified value, is there a function
in excel that can help you to find the correct combination of numbers.
eg in a simple example; if the array of numbers was 2,3,5,6 and the
specified value was 9, we know the only combination of numbers from this
array that would sum to give the value 9 are 6 & 3, however
with a larger array of numbers (20) or more, it would be more difficult
solve the problem manually.
which of those numbers add up to a specified value, is there a function
in excel that can help you to find the correct combination of numbers.
eg in a simple example; if the array of numbers was 2,3,5,6 and the
specified value was 9, we know the only combination of numbers from this
array that would sum to give the value 9 are 6 & 3, however
with a larger array of numbers (20) or more, it would be more difficult
solve the problem manually.