MIN function exclude "Zero" values - Non Consecutive group of cells

[JPScottIII]

I am struggling with ignore zero values when the group of cells to be tested is not a consecutive range

The function "=MIN(D7,M7,V7,AE7,AN7)" works fine but I want to ignore lowest value if AE7 and AN7 are zero.

All the examples for MINIFS require the group of cells to be tested to be a consecutive Range  (D7:AN7) however, I have values in the 7th row that I do not want factored in.

Thanks in advance and I apologize for my nube-ness...

[#2]

@SergeiBaklan 

What about the retrieval of the second smallest postive unique number?

In a range {-1,1,1,8,9} it should be 8.

In a range {-1,1,1,8,8,9} it should be 9.

Note the aim is not the second smallest number by position (which would be 1) but for uniqueness (first unique second smallest value).

[#3]

@Martin_Angosto 

I missed a bit , what exactly do you mean

for {-1,1,1,8,9} positive distinct are {8,9}, first smallest is 8, second smallest is 9

for {-1,1,1,8,8,9} positive distinct are {9}, first smallest is 9, second smallest doesn't exist

[#4]

@SergeiBaklan 

That is the "trick":

The first positive number is counted to be the first (independently if it is not unique).

That is, 1 is the first positive number. It is repeated, but it would be still counted as the first positive number.

However, for the sake of finding the second smallest number, this one should not be repeated. The uniqueness requirement is only affected by the second smallest positive number, the one we are looking to retrieve. Not for the first smallest positive value.

[#5]

@Martin_Angosto 

So, If I understood correctly

=LET(a, {-1,1,1,8,9}, f, FILTER(a,a>0), SMALL(HSTACK(TAKE(f,,1),UNIQUE(f,1,1)),2) )

=LET(a, {-1,1,1,8,8,9}, f, FILTER(a,a>0), SMALL(HSTACK(TAKE(f,,1),UNIQUE(f,1,1)),2) )