In A2 is "Mr A" ???

If YES, just lock the formula....

=MAX(IF($A$2:$A$1650=$A$2,$BO$2:$BO$1650))

If not try in this way..

=MAX(IF($A$2:$A$1650=A2,$BO$2:$BO$1650))

OR else pls upload a small sample workbook.



To attach a small sample workbook.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic