Thread: =MIN() Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
claude jerry claude jerry is offline
external usenet poster
 
Posts: 70
Default =MIN() Function

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