MIN to find specific lowest value
 

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

MIN to find specific lowest value
 

how about a nice array formula which must be entered/edited with
ctrl+shift+enter

=MIN(IF(M2:M220,M2:M22))

--
Don Guillett
SalesAid Software

"Jane" wrote in message
...
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

MIN to find specific lowest value
 

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

"Jane" wrote:

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

MIN to find specific lowest value
 

An "array" 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

"Jane" wrote in message
...
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

"Jane" wrote:

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

MIN to find specific lowest value
 

Thank you Don!

I got it!

appreciate your time and information.... jane

"Jane" wrote:

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

MIN to find specific lowest value
 

glad it helped


--
Don Guillett
SalesAid Software

"Jane" wrote in message
...
Thank you Don!

I got it!

appreciate your time and information.... jane

"Jane" wrote:

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