View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Minimum non-zero value

This is an ARRAY formula that must be entered using ctrl+shift+enter
=MIN(IF(H2:K20,H2:K2))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Derrick" wrote in message
...
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?