Minimum without zeros or negatives

[Hope]

A B C D E
0125 0.0% 0.0% 3.3% 0.0%
0108 0.0% 0.0% 1.2% 0.0%
0110 0.0% 0.0% 3.9% 0.0%
0104 6.3% 0.0% 0.0% 0.0%
0 -100.0% -100.0% -100.0% -100.0%
0 -100.0% -100.0% -100.0% -100.0%
0 -100.0% -100.0% -100.0% -100.0%

I have two issues that I cannot resolve.

I need to return the minimum result from the above column d excluding zero
and the negative numbers. I have tried =min(if(d1:d7>0,d1:d7) with no luck.

I also need to return the corresponding information in column A from the
selected minimum value in column D.

Thanks in advance for your help.

 

[N harkawat]

For minimum after entering the following formula press "Ctrl+Shift+Enter"
=MIN(IF(D17<>0,D17))

Say you entered the above formula in cell D9 a simple vlookup in any cell
would get you the corresponding Col D
=index(a1:a7,match(d9,d1:d7,0))

 

[Bernard Liengme]

Your formula should work if you commit it with CTRL+SHIFT+ENTER as it is an
array formula
For part 2, see help under LOOKUP and come back with additional questions
best wishes

 

[JE McGimpsey]

Did you enter your array formula with CTRL-SHIFT-ENTER?

If so, what does "no luck" mean to you?