Find MIN in a range, but define Minimum number, i.e., >0

[scoobyblue]

I have some data that I want to identify the minimum number but I don't want the answer to be zero (numbers in data range are either positive or zero) . How can I do this?

 

[Lewiy]

For the range A1:A10

=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)

 

[scoobyblue]

Thank you

Cheers,
Scoobyblue

 

[Peter_SSs]

An alternative ...

Excel Workbook
	A	B	C
1	5		Min > 0
2	3		2
3	2
4	0
5	2
6	8
7	6
8
9	7
10	8
Min > 0