View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic Domenic is offline
external usenet poster
 
Posts: 256
Default 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