|
|
Return Numerical Label for LAST value Subtracted to reach Sum Target Value
Hi Domenic,
That's Great!
Cheers,
Sam
Domenic wrote:
D1:
=ROWS(Values)-MATCH(TRUE,SUBTOTAL(9,OFFSET(Values,ROWS(Values)-1,0,-SMALL
(ROW(Values)-MIN(ROW(Values))+1,ROW(Values)-MIN(ROW(Values))+1)))=C1,0)+1
...confirmed with CONTROL+SHIFT+ENTER
E1:
=LOOKUP(2,1/(A1:INDEX(NumLabels,D1)0),A1:INDEX(NumLabels,D1))
Note that I've assumed that your data doesn't contain negative numbers.
Hope this helps!
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1
|