Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|