Remove duplicates (column A), based on highest value in column B?

So I use Twitter and I sometimes export my tweet statistics to look at which ones are performing better than others.

I sometimes tweet the same thing every 2-3 weeks, as I get new followers, followers live in different timezones etc. Therefore a report sometimes has duplicate tweets with different data (date, impressions, clicks etc)

What I'm wanting to do is, remove duplicate tweets (and that entire row) in the excel spreadsheet, leaving the one with the highest engagement rate.

Example...
col A - B
Tweet - Engagement Rate - Clicks

Tweet 1 - 5.34% - 143
Tweet 2 - 4.66% - 165
Tweet 3 - 4.98% - 84
Tweet 1 - 4.34% - 444
Tweet 2 - 3.66% - 92
Tweet 3 - 5.98% - 66

What will be shown after dupes removed:

Tweet 1 - 5.34% - 143
Tweet 2 - 4.66% - 165
Tweet 3 - 5.98% - 66

As these have had the highest engagement vs their other duplicates.

This ignores the click count.

Can this be done in Excel without the need of entering a formula into a cell, and if not, does anybody know what formula I'll need?

Hi Alan,

I've found a link online, but it's not letting me post.

1. Select and copy column A which contains the duplicate values, and paste them to another place.
2. Then select the values in the pasted list, and click Data > Remove Duplicates, and check Continue with the current selection option from the popped out dialog. Click Remove Duplicates, then in the Remove Duplicates dialog, check the column you want to remove duplicates from.
3. Then click OK, and a dialog pops out to remind you how many duplicates have been removed, click OK to close it.
4. Select a cell next to the list you have removed the duplicates from, enter this formula =MIN(IF($A$2:$A$12=D2,$B$2:$B$12)), press Shift + Ctrl + Enter keys, and drag fill handle down to the cell you need.

If you want to remove all duplicates but leave the highest ones, you can apply this formula =MAX(IF($A$2:$A$12=D2,$B$2:$B$12)), remember to press Shift + Ctrl + Enter keys.

Could this also work?

Originally Posted by alansidman

Did you test? Did it give you expected results? Only you will know if you get the results you want!

I'm away from my PC, on my mobile - I was just running it by you to see if it looks like it could work before I get home.

I assume you're an Excel expert, so you may have spotted something incorrect.