Thread: Minimum Calculation
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Minimum Calculation
One way, assuming no negative numbers:

=LARGE(A:A,COUNTIF(A:A,"0"))

In article ,
Ken wrote:

I have a column of numbers, including zeros. I want to find the minimum
number, but not zero. Is there an Excel calculation?
Reply With QuoteReply With Quote