Min but not quite...

[Guest]

Hi...

Not exactly programming but a strange formula. I want to track the minimum
value within a range but want to ignore zeros...is this possible?

Thanks

Gordon.

 

[Paul B]

Gordon, here is one way,

=MIN(IF(A1:A10>0,A1:A10))



this is an array formula, enter with Ctrl+shift+enter
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Bob Umlas]

that must be ctrl/shift/entered

Gordon, here is one way,

=MIN(IF(A1:A10>0,A1:A10))



this is an array formula, enter with Ctrl+shift+enter
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003