ex: A1:A10 is 10,20,30,0,40,50,60,70,80,90.

Not sure how much "robustness" you want/need but try these.

Assuming there are no negative numbers:

For the MIN:

=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)

For the MAX:

=MAX(A1:A10)

--
Biff
Microsoft Excel MVP


"dal_101" wrote in message
...
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!