Thread
:
Minimum non-zero value
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Minimum non-zero value
This is an ARRAY formula that must be entered using ctrl+shift+enter
=MIN(IF(H2:K20,H2:K2))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Derrick" wrote in message
...
I need to find the minimum non-zero value in a row of numbers - not
necessarily together
ie:
36, 0, 0, 24
i would like the resultant value to be 24
if there is a blank -
36, 0, 0, -
i would like it to be 36
any help?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett