In my excel I have a person entered 3 or more times.
Credit score example
Bob Jones 760
Bob Jones 750
Bob Jones 740
I want to remove the duplicate Bob Jones's but keep ONLY the TOP entry which is 760 the Highest. I already have my sheet auto sorting so the top one will always be the HIGHEST
How can I do this wil a formula or button etc etc thanks for your help
Credit score example
Bob Jones 760
Bob Jones 750
Bob Jones 740
I want to remove the duplicate Bob Jones's but keep ONLY the TOP entry which is 760 the Highest. I already have my sheet auto sorting so the top one will always be the HIGHEST

How can I do this wil a formula or button etc etc thanks for your help