View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default Minimum Calculation

Here's one way:
=SMALL(A1:A20,COUNTIF(A1:A20,0)+1)
counts the number of zero's and gives you the next smallest number that
isn't zero. This assumes values in column A, thru row 20, adjust as
necessary.

"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?

KEN