Thread: Minimum value ignoring zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Caroline Caroline is offline
external usenet poster
  
Posts: 183
Default Minimum value ignoring zero
How can I found the minimum value in a list ignoring the zeros?
for the moment I only know
MinValue = Application.WorksheetFunction.Min(Range("A:A"))
thanks in advance
--
caroline
Reply With QuoteReply With Quote