Finding combinations to equal the total
Posted by Paul Balzano on June 06, 2001 2:27 PM
How can I get Excel to find the combinations of check amounts that equal the Total amount? We receive a total dollar amount from the bank (the known). I have hundreds of check amounts in a range. Some combination if added together will equal the total. There could be 1 check to n checks that could add up to the total. Not all checks are cashed at the same time and there are always check amounts in the range. We are only interested in the combination of check amounts equaling the Total amount. And moving the identified check amounts used out of the range after they become part of the total amount.