Thread
:
Min Function
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
matt3542
external usenet poster
Posts: 60
Min Function
Thanks also Don, that worked perfectly just like Mike's. Also cheers for
giving me a solution for a negative value scenario, it will come prove useful
for future work
Cheers Matt
"Don Guillett" wrote:
This is an array formula that must be entered using ctrl+shift+enter
=MIN(IF(A2:A220,A2:A22))
if you also want to look at negative numbers
=MIN(IF(A2:A22<0,A2:A22))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"matt3542" wrote in message
...
Dear Forum, I would be grateful if anyone could help me find a solution to
the following problem;
I have a column of data that follows the format below. I would like to use
the min function (or a suggested alternative) that would give me the
minimum
value excluding any zero values, i.e if a zero value occurs I want the
result
to ignore this and give me the next minimum value, i.e in the context of
the
data below 1 would be the correct result returned;
0
1
0
3
5
1
7
Many Thanks
Matt
Reply With Quote
matt3542
View Public Profile
Find all posts by matt3542