Maybe...

=MAX(IF(ISNUMBER(MATCH(G17:G24,INDEX(Data,MATCH(H1 3,ID,0),0),0)),H17:H24)
)

and

=MIN(IF(ISNUMBER(MATCH(G17:G24,INDEX(Data,MATCH(H1 3,ID,0),0),0)),H17:H24)
)

Note that both formulas need to be confirmed with CONTROL+SHIFT+ENTER,
not just ENTER.

Hope this helps!

In article <65d575e573e78@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi Biff,

Thanks for reply. I may have lost something in the translation of that last
posting.

Column "H" with the numeric values is already using this CF Formula
=COUNTIF(INDEX(Data,MATCH($H$13,ID,0),0),$G17)
with red interior cell Format applied when the condition is satisfied.

The cells of numeric values that satisfy the CF Formula in column "H" are
red.

I would like to extract the minimum and maximum values in Column "H" from the
cells that satsify the CF.

Cheers,
Sam