=Min(if(and(isnumeric(A1:A500),A1:A5000),A1:A500)

entered with Ctrl+Shift+Enter

since this is an array formula.

--
Regards,
Tom Ogilvy

"oldjay" wrote in message
...
I want to find the smallest number in a column that is not
zero or negative