Remove Duplicates: Move results to different column

[robkrouse]

I don't know why this is so difficult, but i want to find out what the duplicates in column B are. Do you have to use a macro, array, formula, or whatever? lol, am i just missing something here? All i want to do is run the numbers in column B to find out which ones are duplicates, so that i can compare the two files in my companies CRM to figure out which one I should delete.

Does that sound complicated?

Column A has the account #, Column B is the company name. I need to run company name for duplicates. I need to be able to pull both account # and company name for each duplicate.

Thanks for your help in advance.

Remove Duplicates Help.xlsx

[FDibbins]

Based on the data you gave, you could use this in a holder column (I used C) to ID the dups.....
=COUNTIF($B$2:$B$32550,B2)
copied down

Then apply filters (Home tab/Editing/Sort and Filter), and then filter on C, uncheck the "1"

What remains should be the dups (you have a max of 282 dups

[robkrouse]

thanks for the quick response. i have tried this once before, but it didnt work, and it didnt this time either. that is until i saved and re-opened it. it worked like a charm. ty so much for your help.

[FDibbins]

Happy to help and thanks for the feedback

The problem was probably because the file is so big, I had a problem as well