=MIN(values)*(MIN(values)>1)
B Brett Apr 19, 2005 #2 Eg: If your range of values is A1:A7 then you could type the following formula into a cell and press CTRL+SHIFT+ENTER to get the correct result. =MIN(IF(A1:A7>1,A1:A7))
Eg: If your range of values is A1:A7 then you could type the following formula into a cell and press CTRL+SHIFT+ENTER to get the correct result. =MIN(IF(A1:A7>1,A1:A7))
B Bob Phillips Apr 19, 2005 #3 =MIN(IF(A1:A10>1,A1:A10)) which is an array formula, so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct)
=MIN(IF(A1:A10>1,A1:A10)) which is an array formula, so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct)
