=MIN() Function
try the following array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:C50,A1:C5))
--
Gary''s Student - gsnu200737
"claude jerry" wrote:
I Have values in a range A1:C5
which contains for eg. 1, 5, 200, 0, 18, 15 etc etc
I want to Find A minimun from this range but it should ignore Zero. and give
me a min other then Zero
Eg. for the above range =Min(A1:C5) gives = 0
I want it to give me 1 not Zero
Any help please
Claude
|