V Vijay Mar 16, 2010 #5 Non Arrary forumula, =SMALL(A1:A5,COUNTIF(A1:A5,"<0")+1) Adjust your range to suit. Vijay
A Ashish Mathur Mar 17, 2010 #6 Hi, You may also try this. Suppose the data is in range A2:A60. In A1, type the heading, say Amount. In C11, 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.
Hi, You may also try this. Suppose the data is in range A2:A60. In A1, type the heading, say Amount. In C11, 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.