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

Something like this, in say B1,
with the formula confirmed via CTRL+SHIFT+ENTER:
=MIN(IF(A1:A100,A1:A10))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---