Formula Help Required
Can anyone tell me if there is a way Excel can do the following?
I need to work out which amounts are added together to make up a total amount.
eg
If I have a list of numbers i.e
1200
1000
2000
3000
1100
900
3120
And I have a total of 4100 is there a formula that can work out how many
combinations (from the list of numbers) can add up to this total?? ie
1. 1200+900+2000
or 3000+1100
|