I have a set of numbers of which a minimum need to be selected to form a given number.
For example
My data set is 2, 4, 6, 8, 10 and i need to select the minimum number of data that can form the number 12. So in this situation 12 can be achieved by adding 2+4+6 or 6+6. So I need excel to register that 6 needs to be selected twice and discard 2+4+6. What can I do?
