Try something like this:

With values in A1:B10

C1: =LARGE(IF(B1:B1048,A1:A10),2)
That formula returns the 2nd largest value from Col_A where the value in
Col_B is greater than 48.

Note: Commit that array formula by holding down the [Ctrl][Shift] keys and
press [Enter].


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"bob" wrote:

I am trying to set up a formula that finds the maximum value, the
second-highest value, third-highest value, etc. in a column, depending on
whether the values in another column meet a certain criteria.

In Column C, I want to return the highest value in Column A if the value in
Column B is 48 or higher. Then the second-highest value, third-highest, etc.

Example:
Column A Column B
.100 52
.200 14
.300 32
.400 123
.500 101

Can anyone help?

Thanks,
Bob