Max function

[dave8]

I have a worksheet with the following data:


Column A Column B
John 60
Ann 80
Joe 50
John 75
Pete 95
Ann 75
Joe 65



I want to be able to get the highest (or Lowest) score in Column B, based on the Name in Column A. For example, I want the highest score for John. In this case, would be 75. Is there a Max function or something similar to get this?

 

[p45cal]

xxx="Web Training"
num =4
Selection.FormulaArray = "=Max(IF(B2:B" & num & " = " & """" & xxx & """" & ", E2:E16))"

 

[dave8]

Thanks to both for the Formula. It works!! I like to take this a step further and only provide a Max if the value in Column A = "" and Column G = "Yes". How to add this in the IF statement within the formula?