MIN to find specific lowest value

J

Jane

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
 
D

Don Guillett

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

=MIN(IF(M2:M22>0,M2:M22))
 
J

Jane

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
 
D

Don Guillett

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