How to calculate non-zero minimum value?
But I don't think that formula works correctly if there are negative
numbers?
--
David Biddulph
"RagDyer" wrote in message
...
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!
|