View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default finding minimum value excluding zero

The best way I can think of to do this would be to insert a "helper"
column next to the list of values, then write a formula like this one
=IF(a10,a1,"")
....and then copy/paste that formula for each value in the list. This
will return only the values that are greater than zero; you can then
use the MIN() function over that range to find the smallest non-zero
value.

Dave O