find smallest positive number among datas

  • Thread starter Thread starter Cerberus
  • Start date Start date
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.
 
Back
Top