Dears,
What I am trying to do is a little hard to explain without confusion, so lets give a first try:
In a given cell range where each cell has a different number, I wanna calculate how many of those cells are needed to sum a given value.
For instance, imagine that we have the following values one in each cell:
2 2 2 3 3 8 9 12 16 19 24
Looking those values, we know that the minimum number of cells one should sum to achieve 50 is equal 3 because 24 + 19 + 16 > 50.
But how could we design a formula to count that automatically even in cases with lots of cell being analysed?
Bookmarks