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