Hi Domenic,

Thank you very much. Formulas works very well.

Cheers
Sam

Domenic wrote:
To return the minimum and maximum, we can adapt Ron's formulas as
follows...

=MIN(IF(A2:A100<"",IF(COUNTIF(A2:A100,A2:A100)/COUNT(A2:A100)C2,A2:A100
)))

and

=MAX(IF(COUNTIF(A2:A100,A2:A100)/COUNT(A2:A100)C2,A2:A100))

...where C2 contains your criteria, such as 70% or .70. Both these
formulas need to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

With regards to filtered data, I would use a formula or several formulas
(for efficiency) to create a new list of the filtered data on a separate
sheet (which can be hidden) and then use the above formulas on the new
list.

If you'd like to try it and need help, post back.

Hope this helps!

Hi All,

[quoted text clipped - 18 lines]
Thanks
Sam


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1