View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default How to calculate non-zero minimum value?

If the values are in A1:A10 then you can use an array formula which must be
entered with Ctrl+Shift+Enter, not just Enter

=MIN(IF(A1:A10<0,A1:A10))

Tyro

"yhoy" wrote in message
...
I have a list of data. want to get the lowest non-zero value. How to set up
the formula?

Thanks!