View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default 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