Removing duplicate by comparing with another column [Closed]

Report
-
Hello,

I am working on an excelsheet where I need to remove the duplicates.

Example:
Column A Column B
Doc A 1
Doc A 0
Doc A 2
Doc B 3
Doc B 4

I would like to keep one document with largest number on column B. and remove other duplicates. How should I do it ?
Should I create a macro or there is a command that can recognize the duplicate and compare to other column and remove the older duplicates ?

Kindly let me know,

Thanks,

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!