Prev: Selecting rows with the same criteria
Next: How do I get drop-down list that includes, eg top10
From: Vijay on 16 Mar 2010 07:57
Non Arrary forumula,

=SMALL(A1:A5,COUNTIF(A1:A5,"<0")+1)
Adjust your range to suit.

Vijay

"David Biddulph" wrote:

> =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: Ashish Mathur on 16 Mar 2010 20:58
Hi,

You may also try this. Suppose the data is in range A2:A60. In A1, type
the heading, say Amount. In C1:D1, type Amount (copy from cell A1). In C2,
type >0. In D2, type =dmin($A$1:$A$60,D$1,C$1:C2)

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"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?

First  |  Prev  | 
Pages: 1 2
Prev: Selecting rows with the same criteria
Next: How do I get drop-down list that includes, eg top10