View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
 
Posts: 247
Default Return Min & Max value of Conditional Formatted cells

Hi Domenic,

Perfect! Thank you once again.

Cheers,
Sam

Domenic wrote:
Sorry! Try the following instead...


=INDEX(G17:G24,MATCH(J13,IF(ISNUMBER(MATCH(G17:G2 4,INDEX(Data,MATCH(H13,I
D,0),0),0)),H17:H24),0))


and


=INDEX(G17:G24,MATCH(J14,IF(ISNUMBER(MATCH(G17:G2 4,INDEX(Data,MATCH(H13,ID,0),0),0)),H17:H24),0))


Both formulas need to be confirmed with CONTROL+SHIFT+ENTER.


Hope this helps!


--
Message posted via http://www.officekb.com