| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, how can I print a long list on 1 page in multiple colum. | Excel Discussion (Misc queries) | |||
| Mailing list in Excel | Excel Discussion (Misc queries) | |||
| how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
| How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
| How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
