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

So smallest positive? That'd mean 0, but your subject line says 1.

This can be done in general without array formulas as

=SMALL(range,COUNTIF(range,"<="&x)+1)

which returns the smallest value in range greater than x. That said,
the array formula

=MIN(IF(rangex,range))

is more efficient - faster recalc, uses fewer resources.