If Greater than this column and this column then Max and Min and display this cell

[jshonuff]

[TABLE="width: 500"]
<tbody>[TR]
[TD]NAME
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD][/TD]
[TD]0%
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]561
[/TD]
[TD]91%
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]560
[/TD]
[TD]86%
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD][/TD]
[TD]0%
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


If Column A is Greater than 0 and Column B is greater than 90, then find the MAX of column B, and display Name Cell.
It should give you (1).

Also the same as above but instead of MAX I need the MIN Value as well.
Should be (2).
Thanks

 

[Gerald Higgins]

Also the same as above but instead of MAX I need the MIN Value as well.
Should be (2).

This seems to ignore the test for column B being greater than 90.
Is that correct ?

 

[jshonuff]

Sorry No, I still need that to find the Min or it will go to one of the ones with a zero.
Even though 0 is smaller than 86%, I need it to know that 86% is the lowest somehow.

 

[Gerald Higgins]

OK.

Is it POSSIBLE that ALL the numbers in Column B are less than 90% ?
If yes, what to do then ?

 

[jshonuff]

Sorry for the last post it would have to be less than 90% for the Min (not greater than). Hope than helps.
Bottom line I think what you was asking before is correct or just ignore the 90%.

 

[Gerald Higgins]

OK I'm getting confused now.

Please can you post a larger sample of data - say maybe 10 lines ?
Say about 5 lines where column B entries are different and all above 90%, and another 5 lines where column B entries are again different and all below 90% ?
Mix these in with multiple different values in Column A.
Then say what the results should be please.