View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ezil ezil is offline
external usenet poster
 
Posts: 43
Default finding minimum value

I have to find minimum value in a range of column for eg. a1 to a100 other
than zero.
The formula "=min(a1:a100)" returns value 0 if the minimum value is 0 but I
require
the minimum value other than zero (all my values are in positive side only)