View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dal_101 dal_101 is offline
external usenet poster
 
Posts: 1
Default getting the min and max of a list of numbers

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!