Hi Domenic,
The Formulas below do return Numeric Labels for minimum and maximum values
but they are not the Numeric Labels for the actual minimum and maximum
Numeric Values that have the CF Formula applied to them.
Further help most appreciated.
Cheers,
Sam
Domenic wrote:
Assuming that J13 and J14 contain the formulas returning the maximum and
minimum values, try...
=INDEX(G17:G24,MATCH(J13,H17:H24,0))
and
=INDEX(G17:G24,MATCH(J14,H17:H24,0))
Note that the formula will only return the first occurrence. Post back
if there can be more than one occurrence of maximum and minimum values.
Hope this helps!
Hi Domenic,
[quoted text clipped - 26 lines]
Cheers,
Sam
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200609/1