Alright, so here is a question that has been nagging me for some time now:
Is there a way in excel to find what combination of numbers in a list equals a preset number.
Example: I have $575,000 in sales from one system but only $565,000 is showing up in another system. I am trying to find out which sales transactions are missing. I want to know what combination of the sales transactions could total this variance exactly. The issue is I do not know if it is a single transaction (of course i can eyeball this) or even 23 or 33 transactions.
I would expect that more than one answer to occur based on the data but at least this would narrow down the possible errors....
any help would be appreciated
Bookmarks