To exclude 0's and negatives, you could try:

=Small(A1:A50,1+Countif(A1:A50,0))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Kendo" wrote in message
...

I need a formula to show the lowest figure, but not 0 in an excel
spreadsheet.

Can anyone help???!!