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.
|