Please help me on how to create a formula for this. if you have given someone 4 numbers, such as
And a person would generate a total back to you such as 5000 to compare to the list of numbers you provided.
Question is what could be the formula in getting the list of numbers not included to when summed to 5000?
Visually we could solve that easily, that is it could be either 2000 and 3000 = 5000 so that answer would be the list of number not included are 1000 and 4000. but how will we solve this through a formula?