Thread
:
MIN to find specific lowest value
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
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
Reply With Quote