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:d70,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.

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

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))

"Hope" wrote:

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:d70,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.

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

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Hope" wrote in message
...
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:d70,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.

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

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


In article ,
Hope wrote:

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:d70,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.