Posted to microsoft.public.excel.worksheet.functions
|
|
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
|