View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Val Val is offline
external usenet poster
 
Posts: 32
Default Min. Value is Needed

I am trying to determine the min value of a column using the MIN command.

The column has the following values:
2
34
6
0
0
1

I would the minium value greater then zero to be displayed in a cell. I
have been able to use the Max command to determine the mx number but and Min
command displays 0 or if I setup a negative number it will display that
value.

Any suggestions?