Thread
:
Minimum non-zero value
View Single Post
#
1
Posted to microsoft.public.excel.misc
Derrick
external usenet poster
Posts: 133
Minimum non-zero value
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
Derrick
View Public Profile
Find all posts by Derrick