Return Numerical Label for LAST value Subtracted to reach Sum Target Value
For robustness...
D1:
=ROWS(Values)-MATCH(TRUE,MMULT(--(ROWS(Values)-(ROW(Values)-MIN(ROW(Value
s))+1)+1<=TRANSPOSE(ROW(Values)-MIN(ROW(Values))+1)),Values)=C1,0)+1
....confirmed with CONTROL+SHIFT+ENTER.
Hope this helps!
In article ,
Domenic wrote:
Shorter...
D1:
=ROWS(Values)-MATCH(TRUE,MMULT(--(ROWS(Values)-ROW(Values)+1<=TRANSPOSE(R
OW(Values))),Values)=C1,0)+1
...confirmed with CONTROL+SHIFT+ENTER.
Hope this helps!
|