oldjay

One way:

=MIN(IF(B2:B1000,B2:B100))

This is an array formula to be entered with <Shift<Ctrl<Enter,
also if edited later. If done correctly, Excel will display the formula
in the formula bar enclosed in curly brackets { }. Don't enter these
brackets yourself.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"oldjay" skrev i en meddelelse
...
I want to find the smallest number in a column that is not
zero or negative