Highest value in column

[Savvyn]

I'm hoping someone can help with something I'm trying to do at work. Here's the basic situation:

Column A consists of names and each name shows up 1-20 times. Column B consists of numbers. I am trying to highlight or somehow identify the highest number corresponding to each name. Is there a formula for this?

 

[Aladin Akyurek]

1. Try a pivot table.

2. In C2 enter and copy down:

=MAXIFS(B:B,A:A,$A2)

3. If you get a #NAME? error on [2], in C2 enter and copy down:

=AGGREGATE(14,6,$B$2:$B$8/($A$2:$A$8=$A2),1)

4. Try to create a unique list in column E by means of Advanced Filter and invoke in F2 one of the foregoing formulas where you replace A2 with E2.