View Single Post
  #8   Report Post  
Sam via OfficeKB.com
 
Posts: n/a
Default Return Numerical Label for LAST value Subtracted to reach Sum Target Value

Hi Ron,

Ron Rosenfeld wrote:
I misread your specifications. The correct formula would be:


=INDEX(A1:A30,MATCH(D1,C1:C30,-1))


Your Formula does now provide exactly what I requested. Unfortunately, I over
simplified the example: in a few cases the Numeric Label above the Summed
Target Value could be zero (0). Is there anyway of adapting your existing
Formula to exclude any Numeric Labels of zero (0) and thus return what would
be the next non-zero Numeric Label.

Apologies for my over simplified example.

Further assistance much appreciated.

Cheers,
Sam


Ron Rosenfeld wrote:
Hi All,

[quoted text clipped - 71 lines]

--ron


I misread your specifications. The correct formula would be:

=INDEX(A1:A30,MATCH(D1,C1:C30,-1))

--ron



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1