I am trying to create a formula in excel to determine the minimum value in column C based on the following:

1. Find all rows where column A = Mark.
2. Find all rows = Mark, determine the maximum value in Column B.
3. For the maximum column B values associated with Mark, determine the minimum value in Column C.

Answer = 200



Column A Column B Column C
Mark 6 300
Mark 6 200
John 6 10
Mark 5 3

I know I could sort my data for each of the three columns and use vlookup. I am trying to come up with a formula in which I do not need to sort the data.