in trying to find a min value, how do i exclude zeros from the list to be looked at?
J jtribe Feb 26, 2005 #1 in trying to find a min value, how do i exclude zeros from the list to be looked at?
B Biff Feb 26, 2005 #2 Hi! Array entered with the key combo of CTRL,SHIFT,ENTER: =MIN(IF(A1:A100<>0,A1:A100)) Biff
K Ken Wright Feb 26, 2005 #3 That won't exclude zeroes. You can use SMALL but will still need to use something like Biff's example, eg =SMALL(IF(Rng<>0,Rng),1) array entered. or =SMALL(IF(Rng,Rng),1) array entered.
That won't exclude zeroes. You can use SMALL but will still need to use something like Biff's example, eg =SMALL(IF(Rng<>0,Rng),1) array entered. or =SMALL(IF(Rng,Rng),1) array entered.
