find smallest positive number among datas
 

How to find the smallest positive number among datas in Excel?

find smallest positive number among datas
 

Try

=MIN(data_rng)

--

HTH

Bob

"Cerberus" wrote in message
...
How to find the smallest positive number among datas in Excel?

find smallest positive number among datas
 

=MIN(IF(A1:A60,A1:A6)) as an array formula (Control Shift Enter)
Adjust your range to suit.
--
David Biddulph


"Cerberus" wrote in message
...
How to find the smallest positive number among datas in Excel?

find smallest positive number among datas
 

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?

find smallest positive number among datas
 

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?

find smallest positive number among datas
 

Non Arrary forumula,

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

Vijay

"David Biddulph" wrote:

=MIN(IF(A1:A60,A1:A6)) as an array formula (Control Shift Enter)
Adjust your range to suit.
--
David Biddulph


"Cerberus" wrote in message
...
How to find the smallest positive number among datas in Excel?


.

find smallest positive number among datas
 

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" wrote in message
...
How to find the smallest positive number among datas in Excel?