How do I find the minimum value in a range while ignoring zeros?
If the numbers are *always* positive..
Array entered**:
..=MIN(IF(A1:A100,A1:A10))
Or, normally entered:
=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
If there might be negative numbers...
Array entered**:
=MIN(IF(A1:A10<0,A1:A10))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
--
Biff
Microsoft Excel MVP
"Ted B." wrote in message
...
-- How do I find the minimum value in a range while ignoring any zeros in
that range using Excel 2007?
|