View Single Post
  #9   Report Post  
Sam via OfficeKB.com
 
Posts: n/a
Default 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