MIN function
Vanessa
Try this
=MIN(IF(D1:D200,D1:D20))
This is an array formula which must be entered with CTRL+Shift+Enter and NOT
just by pressing enter. If you do it correctly Excel will put cur;y brackets
{} around the formula. You can't type these yourself
Mike
"vanessa" wrote:
I am having difficulty writing a formula to find the MIN of a list of
non-consecutive numbers that contains a lot of zeros. The formula keeps
returning zero.
How do I find the MIN greater than zero?
|