What formula do i use to find the lowest number in a set of figures, but ignoring blanks and zero's
J James Oct 24, 2004 #1 What formula do i use to find the lowest number in a set of figures, but ignoring blanks and zero's
F Frank Kabel Oct 24, 2004 #2 Hi try the following array formula (entered with cTRL+SHIFT+ENTER): =MIN(IF(A1:A100<>0,A1:A100))
A Aladin Akyurek Oct 24, 2004 #3 =MIN(IF(Range,Range)) which you need to confirm with control+shift+enter instead of just wit enter.
