Mar 12 2023 12:07 PM
Hi,
In our firm, we use one spreadsheet listing all invoices submitted under each separate project, sometimes the client transfers a lumpsum and we need to manually compare the invoices to find the correct breakdown for which invoices have been reimbursed.
E.g. So let's suppose that a specific column has values from 1 to 9, and the client transferred an amount of 17, is there a formula that can deduce the possibilities that would tell me which invoices would match to 17, instead of me having to search manually and narrow it down to 8+9 ? (of course I'm talking about many invoices with amounts in thousands).
Thanks.
Mar 12 2023 01:13 PM
Mar 12 2023 01:34 PM
Thank you for your reply, but it didn't work. it gives me the value of 0. from what I understood it it didn't find the value of 17 therefore it equaled 0.
what I want to know is which of the values in column A could equal 17, and how many if more than one option.
Mar 12 2023 02:02 PM
Another solution! You can use the Solver add-in in Excel to find the combination of values in the column that add up to 17.
Here are the steps to follow:
5. Click on the "Options" button and make sure that the "Assume Linear Model" option is unchecked.
6. Click on the "Solve" button and wait for Solver to find a combination of values that add up to 17.
7. If Solver finds a solution, click on the "OK" button to apply the solution to your worksheet.
Note that Solver may not always find a solution, especially if there are no combinations of values that add up to 17. In that case, you may need to adjust the values in the column or try a different approach. Also, Solver is an add-in that may need to be installed and enabled in Excel before you can use it.