If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




How to calculate nonzero minimum value?
I have a list of data. want to get the lowest nonzero value. How to set up
the formula? Thanks! 
Ads 
#2




How to calculate nonzero 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 nonzero value. How to set up > the formula? > > Thanks! 
#3




How to calculate nonzero minimum value?
Nonarray 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 nonzero value. How to set >>up >> the formula? >> >> Thanks! > > 
#4




How to calculate nonzero minimum value?
But I don't think that formula works correctly if there are negative
numbers?  David Biddulph "RagDyer" > wrote in message ... > Nonarray 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 nonzero value. How to set >>>up >>> the formula? >>> >>> Thanks! >> >> > > 
#5




How to calculate nonzero minimum value?
You're absolutely right.
However, as I mentioned in a thread yesterday concerning averaging without zeroes, the transition from positive to negative predisposes the presence of zeroes. Therefore, one can assume ... no 0's ... no negatives. Though your point is well taken, since we never actually know how or where our suggestions will be used.  Regards, RD  Please keep all correspondence within the Group, so all may benefit !  "David Biddulph" <groups [at] biddulph.org.uk> wrote in message ... But I don't think that formula works correctly if there are negative numbers?  David Biddulph "RagDyer" > wrote in message ... > Nonarray 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 nonzero value. How to set >>>up >>> the formula? >>> >>> Thanks! >> >> > > 
#6




How to calculate nonzero minimum value?
.... or abused.
 Jon  Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc.  http://PeltierTech.com _______ "RagDyeR" > wrote in message ... > You're absolutely right. > > However, as I mentioned in a thread yesterday concerning averaging without > zeroes, the transition from positive to negative predisposes the presence > of > zeroes. > > Therefore, one can assume ... no 0's ... no negatives. > > Though your point is well taken, since we never actually know how or where > our suggestions will be used. >  > > Regards, > > RD >  > Please keep all correspondence within the Group, so all may benefit ! >  > > "David Biddulph" <groups [at] biddulph.org.uk> wrote in message > ... > But I don't think that formula works correctly if there are negative > numbers? >  > David Biddulph > > "RagDyer" > wrote in message > ... >> Nonarray 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 nonzero value. How to set >>>>up >>>> the formula? >>>> >>>> Thanks! >>> >>> >> >> > > > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
How to calculate minimum distance between three coordinate with ex  Jonathan[_2_]  Excel Discussion (Misc queries)  2  November 29th 07 04:12 AM 
Minimum Value  Alex  Excel Worksheet Functions  2  August 1st 07 03:44 PM 
How to lookup the minimum, 2nd minimum and 3rd minimum.........  Mark McDonough  Excel Worksheet Functions  8  July 15th 06 09:39 PM 
minimum  ridash  Excel Worksheet Functions  4  June 23rd 06 03:00 PM 
Calculate Minimum numbers  Pete  Excel Worksheet Functions  2  May 12th 05 04:31 PM 