I'd use Openoffice Calc (free) or Excel (if you're minted)
Sort the list alphabetically, then in the column next to it (Column B most likely) do an "If" command
If A2 = A1;"Duplicate";"Unique"
Then copy column B and paste back over itself as "Value Only"
Then sort by column B alphabetically. This will separate all the dupes from the unique - the delete the block of duplicates (they will be in one block easy to delete)
Other stuff like sorting my email provider, sporting alphabetically, splitting the list etc. All done in a few seconds in a spread-sheet. You can even send email from within Excel these days.
Not the idea solution, and there is software out there that will do more for you. But Openoffice is 100% free and most list manipulation is a cinch once you've cracked 2 or 3 principles.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.