Return Min & Max value of Conditional Formatted cells
Sorry! Try the following instead...
=INDEX(G17:G24,MATCH(J13,IF(ISNUMBER(MATCH(G17:G24 ,INDEX(Data,MATCH(H13,I
D,0),0),0)),H17:H24),0))
and
=INDEX(G17:G24,MATCH(J14,IF(ISNUMBER(MATCH(G17:G24 ,INDEX(Data,MATCH(H13,I
D,0),0),0)),H17:H24),0))
Both formulas need to be confirmed with CONTROL+SHIFT+ENTER.
Hope this helps!
In article <65d7dd104fcb6@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:
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
|