Apr 14 2022 04:26 PM
Hello,
I have several customers that pay by invoice instead of statement. They have balances older than 90 days, but not as old as 120 days. I have all their invoices from the time frame in question on a spreadsheet. I have the invoice dollar amounts in A2 through A34, with their corresponding Invoice Numbers in D2 through D34. I have the Target Amount in F2. What I am trying to do is see what combination of invoices would total the Target Amount. I am using Microsoft 365 with the Solver add-in turned on. I'm thinking it should be fairly simple, but I am stumped.
Thank you for any assistance,
William