View Single Post
  #1   Report Post  
Homeboy
 
Posts: n/a
Default Can Excel Choose from a List What Makes a Particular Total?

Suppose a customer has 60 unpaid invoices. The customer sends me a check
paying a certain number of the invoices but doesn't indicate how many
invoices or which ones. Let's assume I cannot contact the customer for more
information. Is there a way to put all 60 amounts in Excel along with the
amount of the check and have Excel try all possible combinations of those
invoices to determine which combination, if any, matches the amount of the
check?