C
Cerberus
How to find the smallest positive number among datas in Excel?
B
Bob Phillips
Try
=MIN(data_rng)
=MIN(data_rng)
D
David Biddulph
=MIN(IF(A1:A6>0,A1:A6)) as an array formula (Control Shift Enter)
Adjust your range to suit.
Adjust your range to suit.
J
Jacob Skaria
Try the below to return the max positive from Col A
=MAX(0,A:A)
=MAX(0,A:A)
J
Jacob Skaria
I have misread your post..Refer the post from David...
V
Vijay
Non Arrary forumula,
=SMALL(A1:A5,COUNTIF(A1:A5,"<0")+1)
Adjust your range to suit.
Vijay
=SMALL(A1:A5,COUNTIF(A1:A5,"<0")+1)
Adjust your range to suit.
Vijay
A
Ashish Mathur
Hi,
You may also try this. Suppose the data is in range A2:A60. In A1, type
the heading, say Amount. In C1
1, 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.
You may also try this. Suppose the data is in range A2:A60. In A1, type
the heading, say Amount. In C1
1, 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.