Having issues with export emails and finding duplicates

Hello Everyone,

Has anyone run into this problem? … I have downloaded 2 lists from phplist. One list is my full mailing list, and the other contains a select group that may or may not be in the full list. But using Excel, the “find duplicates” command is not showing any duplicates, and I know there are at least 300. Any help would be appreciated. Removing the duplicates by hand is really time consuming. Thank you

I just solved this. You have to format all the emails as text, and then the conditional formatting will work to show you all the duplicates.


I do not get it. Can you make it easier for the beginners like me?