Hello,
I am trying to do the following.

Column A, Column B
John, 2
John, 3
John, 1
Max, 1
Max, 10
..

In column C, I would like Excel to select the maximum value from column B for each individual. Is there a way to do this?
Thanks for any help.