software

my data:
0
0
0
0
..01
..93
..03
I need to find the lowest value NOT including 0.
help with formula please..... thank you! jane
how about a nice array formula which must be entered/edited with
ctrl shift enter

=MIN(IF(M2:M22gt;0,M2:M22))

--
Don Guillett
SalesAid Software

quot;Janequot; gt; wrote in message
...
gt; my data:
gt; 0
gt; 0
gt; 0
gt; 0
gt; .01
gt; .93
gt; .03
gt; I need to find the lowest value NOT including 0.
gt; help with formula please..... thank you! jane
gt;
gt;
Hi Don,
I tried the enter the formula at the end of my column but received #VALUE!.
can you clarify what you mean by enter/ edit the array by using shift control
enter?
thank you, jane

quot;Janequot; wrote:

gt; my data:
gt; 0
gt; 0
gt; 0
gt; 0
gt; .01
gt; .93
gt; .03
gt; I need to find the lowest value NOT including 0.
gt; help with formula please..... thank you! jane
gt;
gt;

An quot;arrayquot; formula must be entered/edited with ctrl shift enter vs only
using the enter key. So when you create or change this formula hold down the
control key and the shift key and touch the enter key. you will then see
{ } around the formula. This must be done whenever you make a change
but NOT when copying down.

--
Don Guillett
SalesAid Software

quot;Janequot; gt; wrote in message
...
gt; Hi Don,
gt; I tried the enter the formula at the end of my column but received
gt; #VALUE!.
gt; can you clarify what you mean by enter/ edit the array by using shift
gt; control
gt; enter?
gt; thank you, jane
gt;
gt; quot;Janequot; wrote:
gt;
gt;gt; my data:
gt;gt; 0
gt;gt; 0
gt;gt; 0
gt;gt; 0
gt;gt; .01
gt;gt; .93
gt;gt; .03
gt;gt; I need to find the lowest value NOT including 0.
gt;gt; help with formula please..... thank you! jane
gt;gt;
gt;gt;
Thank you Don!

I got it!

appreciate your time and information.... jane

quot;Janequot; wrote:

gt; my data:
gt; 0
gt; 0
gt; 0
gt; 0
gt; .01
gt; .93
gt; .03
gt; I need to find the lowest value NOT including 0.
gt; help with formula please..... thank you! jane
gt;
gt;

glad it helped--
Don Guillett
SalesAid Software

quot;Janequot; gt; wrote in message
...
gt; Thank you Don!
gt;
gt; I got it!
gt;
gt; appreciate your time and information.... jane
gt;
gt; quot;Janequot; wrote:
gt;
gt;gt; my data:
gt;gt; 0
gt;gt; 0
gt;gt; 0
gt;gt; 0
gt;gt; .01
gt;gt; .93
gt;gt; .03
gt;gt; I need to find the lowest value NOT including 0.
gt;gt; help with formula please..... thank you! jane
gt;gt;
gt;gt;