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

[jshonuff]

NAME	A	B	C
D		0%
1	561	91%
2	560	86%
A		0%

<tbody>
</tbody>

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.