It worked for me.

Signature
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
> What would the formula for minimum be?
> I tried to replace Max wih min but it doesnt work.
> Would appreciate an answer on this,
> regards
> m
=MIN(IF(ISNUMBER(FIND({"Park","Space"},A1:A10)),C1:C10,MAX(C1:C10)))
Also entered using Ctrl-Shift-Enter.
HTH,
Bernie
MS Excel MVP
> What would the formula for minimum be?
> I tried to replace Max wih min but it doesnt work.
> Would appreciate an answer on this,
> regards
> m
Harlan Grove - 19 Dec 2005 00:27 GMT
"Bernie Deitrick" <deitbe @ consumer dot org> wrote...
>=MIN(IF(ISNUMBER(FIND({"Park","Space"},A1:A10)),C1:C10,MAX(C1:C10)))
>
>Also entered using Ctrl-Shift-Enter.
...
Or
=-MAX(IF(ISNUMBER(FIND({"Park","Space"},A1:A10)),-C1:C10))