Prev: Selecting rows with the same criteria
Next: How do I get drop-down list that includes, eg top10
From: Cerberus on 16 Mar 2010 04:13
How to find the smallest positive number among datas in Excel?
From: Bob Phillips on 16 Mar 2010 04:27
Try

=MIN(data_rng)

--

HTH

Bob

"Cerberus" <Cerberus(a)discussions.microsoft.com> wrote in message
news:8616B833-5582-4FCE-A23C-5F10D577AF63(a)microsoft.com...
> How to find the smallest positive number among datas in Excel?


From: "David Biddulph" groups [at] on 16 Mar 2010 04:27
=MIN(IF(A1:A6>0,A1:A6)) as an array formula (Control Shift Enter)
Adjust your range to suit.
--
David Biddulph


"Cerberus" <Cerberus(a)discussions.microsoft.com> wrote in message
news:8616B833-5582-4FCE-A23C-5F10D577AF63(a)microsoft.com...
> How to find the smallest positive number among datas in Excel?


From: Jacob Skaria on 16 Mar 2010 04:53
Try the below to return the max positive from Col A

=MAX(0,A:A)

--
Jacob


"Cerberus" wrote:

> How to find the smallest positive number among datas in Excel?
From: Jacob Skaria on 16 Mar 2010 05:15
I have misread your post..Refer the post from David...

--
Jacob


"Jacob Skaria" wrote:

> Try the below to return the max positive from Col A
>
> =MAX(0,A:A)
>
> --
> Jacob
>
>
> "Cerberus" wrote:
>
> > How to find the smallest positive number among datas in Excel?
 |  Next  |  Last
Pages: 1 2
Prev: Selecting rows with the same criteria
Next: How do I get drop-down list that includes, eg top10