Thread: Finding Minimum Value in series, excluding zero values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Finding Minimum Value in series, excluding zero values
Non array formula

=SMALL(A2:G2,COUNTIF(A2:G2,0)+1)


" wrote:

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