Morning all! I've run into a particular snag in sorting/removing duplicates and I was hoping someone could shed some light on the situation.

I have a spreadsheet with quite a bit of information and I need to remove the duplicates within the spreadsheet, keeping duplicates with the highest weighted value of another column.

Column A - Weighted Value of the user's designation.
Column B - User's designation
Column C - User


I need to remove the duplicates in column C so I only have unique user's, but I need to make sure that their highest weighted value is kept in column A.

I have sorted with primary criteria based on user first and weighted value (smallest to largest) sorted. When I remove the duplicates from Column C (while selecting all three columns to make sure I keep all the information necessary), it does not seem to have a rhyme or reason as to which rows it removes as duplicates.

I've tried everything I know how to do. Any chance of a walk through or a little help? Thanks!