View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default How to calculate non-zero minimum value?

Non-array option:

=SMALL(A1:A100,COUNTIF(A1:A100,0)+1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Tyro" wrote in message
. net...
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!