Good Day
Dear team
Attached excel sheet "Solver-1" . I have a list of invoice values in column 1,I add a helper column in B.
I applied sumproduct formula in cell B53 as " =SUMPRODUCT(A19:A52,B19:B52) "
I set desired Set objective $B$53 to the value i want .(here eg:165, which is the amount paid by customerr, but i dont that information from customer which invoices were paid). So i try to get it solved by using SOLVER by applying .My changing cells are $B$19:$B$52 and my contraints are
1) $B$19:$B$52=BINARY
2) $B$19:$B$52=Integer
I opt Simplex LP to get it solved
I always got the result as the sum is a combination of A31 Value 21 + A36 value 91 + A52 Value 53
But i have another combination of A21 Value 79 + A26 Value 65 + A31 Value 21 to give same result 165
This is get only because the figures are small and list is short. How can i get all the possible combinations of value that may lead to result 165
Thanks and regards
Jayaraj
Bookmarks