Thread: Finding Minimum Value in series, excluding zero values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] cpretzinger@comcast.net is offline
external usenet poster
  
Posts: 1
Default Finding Minimum Value in series, excluding zero values
I am trying to find the smallest value in a series, but exclude the
cells that have zero values.

For Example:


A B C D E F G

2 1.1 4 0 0 0 0

I want the return value to be 1.1 (the smallest in the row excluding
0)

Is this possible?

Reply With QuoteReply With Quote