Re: $$Excel-Macros$$ minimum numeric positive value

Hi sundar here is the solution for all without array Min (-)tive value =MIN(A1:A10) Min (+)itive value =SMALL(A1:A10,(COUNT(A1:A10)-COUNTIF(A1:A10,">=0")+1)) Max (-)tive value =LARGE(A1:A10,(COUNT(A1:A10)-COUNTIF(A1:A10,"<0")+1)) Max (+)itive value =MAX(A1:A9) -- *Great

Re: $$Excel-Macros$$ minimum numeric positive value

Try it... {=SMALL(IF(F14:F23>0,F14:F23,""),1)} -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Jul 27, 2011 at 6:33 PM, sundar nayal wrote: > > Hi friends, > > i have a data, in which so many numeric value, some are p

Re: $$Excel-Macros$$ minimum numeric positive value

Hello Sundar, Also, a non array formula with just ENTER. =SMALL(A:A,COUNTIF(A:A,"<=0")+1) HTH Haseeb For tips visit; http://www.excelfox.com/forum -- -- Some important links for excel users: 1. Follow us on TWITTE

Re: $$Excel-Macros$$ minimum numeric positive value

Hi find attach Try : {=MIN(IF($A$2:$A$16>0,$A$2:$A$16))} Thanks Mahesh On Wed, Jul 27, 2011 at 6:33 PM, sundar nayal wrote: > > Hi friends, > > i have a data, in which so many numeric value, some are positive( like > 1,2,3,55,76,871 etc) and some are negative ( like -1,-5,-84,-7,-6 etc), > so

Re: $$Excel-Macros$$ minimum numeric positive value

Dear Sundar, Please try this =MAX(IF(A1:A5<>0,A1:A5,FALSE)) On Wed, Jul 27, 2011 at 6:33 PM, sundar nayal wrote: > > Hi friends, > > i have a data, in which so many numeric value, some are positive( like > 1,2,3,55,76,871 etc) and some are negative ( like -1,-5,-84,-7,-6 etc), > so how can i

$$Excel-Macros$$ minimum numeric positive value

Hi friends, i have a data, in which so many numeric value, some are positive( like 1,2,3,55,76,871 etc) and some are negative ( like -1,-5,-84,-7,-6 etc), so how can i find minimum positive numeric value? example(1,2,3,4,6,-1,-7,-8,-2.) in this data, minimum numeric positive value is 1. please s