Hi,

=MIN(IF(A1:A10<0,A1:A10,""))

and

=MAX(IF(A1:A10<0,A1:A10,""))

Both of these formulas are arrays - to enter them you press Shift+Ctrl+Enter
rather than enter.

If this helps please click the Yes button
--
Thanks,
Shane Devenshire


"dal_101" wrote:

I need to get the maximum and minimum values in a list of numbers, some of
the cells have 0 (suppressed), and I do not want to include those, and not
get the value output 0??? I can not delete the zero values either I just dont
want to include them.

in other words....ex: A1:A10 is 10,20,30,0,40,50,60,70,80,90. How do I get
the min and max of all the numbers except the zero?

Please help!