cells are necessary to equal a specified amount?
For example...total amount is $575.75
10 or 10000 lines:
25.25
50.50
23.65
500
.14
16.54
.46
20
10
50
Here, for example sake, I can easily see which values are required to total 575.75, but I am working with 50000 lines and much larger #s. Does such a formula even exist?
TIA
Financeguy 2014
Bookmarks