I am working on an excelsheet where I need to remove the duplicates.
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,
Removing duplicate by comparing with another column