Min but not quite...
 

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.

Min but not quite...
 

Gordon, here is one way,

=MIN(IF(A1:A100,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




"Gordon" wrote in message
...

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.

Min but not quite...
 

that must be ctrl/shift/entered

"Paul B" wrote in message
...
Gordon, here is one way,

=MIN(IF(A1:A100,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




"Gordon" wrote in message
...

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.