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 day,* *viper * On Thu, Jul 28, 2011 at 11:23 AM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Try it....... > {=SMALL(IF(F14:F23>0,F14:F23,""),1)} > > > > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > On Wed, Jul 27, 2011 at 6:33 PM, sundar nayal <sundar.na...@gmail.com>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 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 suggest.. >> -- >> Thanks & regards, >> Sunder Singh Nayal >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > ** -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
min max.xls
Description: MS-Excel spreadsheet