I want to find the smallest number in a column that is not zero or negative
T Tom Ogilvy Apr 26, 2004 #2 =Min(if(and(isnumeric(A1:A500),A1:A500>0),A1:A500) entered with Ctrl+Shift+Enter since this is an array formula.
=Min(if(and(isnumeric(A1:A500),A1:A500>0),A1:A500) entered with Ctrl+Shift+Enter since this is an array formula.
L Leo Heuser Apr 26, 2004 #3 oldjay One way: =MIN(IF(B2:B100>0,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.
oldjay One way: =MIN(IF(B2:B100>0,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.
