I am not even sure there is a possible way to do this but here is my issue.
I have a simple list with 2 columns which hold account numbers in column 1 and amounts in column 2. I have a total (sum) for 5 accounts which did not show on a report. So I need to find 5 accounts in a list of roughly 2300 accounts only knowing a total amount (sum) and that I need 5 amounts to make up this sum. Algebraically the formula would be x+y+z+a+b= c where c = predefined sum.
I have tried looking at using some type of array sum function but nothing seems like it could fit. I also realize that there may be one or more combinations of 5 values that will equal the predefined sum. I am hoping to make some kind of loop that will continue until the possibilities are exhausted.
I know this is ridiculous, but if it is possible I would like to try it.
Bookmarks