View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Derrick Derrick is offline
external usenet poster
 
Posts: 133
Default Minimum non-zero value

I need to find the minimum non-zero value in a row of numbers - not
necessarily together
ie:
36, 0, 0, 24
i would like the resultant value to be 24
if there is a blank -
36, 0, 0, -
i would like it to be 36

any help?