How to find the minimum value in the range exclude zero.
K Ken Johnson Mar 11, 2006 #2 Hi cutyfurby, this array formula worked for me to return the minimum of A1:A10... =MINA(IF(A1:A10=0,"",A1:A10)) after typing the formula you must commit it using Ctrl + Shift + Enter Ken Johnson
Hi cutyfurby, this array formula worked for me to return the minimum of A1:A10... =MINA(IF(A1:A10=0,"",A1:A10)) after typing the formula you must commit it using Ctrl + Shift + Enter Ken Johnson
J JudithJubilee Mar 11, 2006 #3 Hello cutyfurby, You need an array formula: =MIN(IF(E1:E5>0,E1:E5)) You will need to press Ctrl+Shift+Enter to confirm the formula not just Enter Judith
Hello cutyfurby, You need an array formula: =MIN(IF(E1:E5>0,E1:E5)) You will need to press Ctrl+Shift+Enter to confirm the formula not just Enter Judith
B Biff Mar 11, 2006 #4 How to find the minimum value in the range exclude zero. =MIN(IF(A1:A10<>0,A1:A10)) Entered as an array using the key combo of CTRL,SHIFT,ENTER. Biff
How to find the minimum value in the range exclude zero. =MIN(IF(A1:A10<>0,A1:A10)) Entered as an array using the key combo of CTRL,SHIFT,ENTER. Biff
