One way:

=SMALL(A1:A6,IF(MIN(A1:A6)=0,2,1))

--
Jim
"Melissa" wrote in message
...
| What formula should I use to return the minimum no. in a range of numbers,
| except 0?
| e.g. 1, 4, 7, 0, 6, 8
| The min should be 1 and not 0.