Remove duplicate emails
Tidy the emails in column C, then delete rows whose email is already listed.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Trim extra spaces in C2:C1000
- Make C2:C1000 lowercase
- Remove rows with a repeated email (column 3)
Use it in MacroRoni: open the Starter gallery, search for "Remove duplicate emails", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More clean up macros
Clean upTidy a messy listTrim spaces, remove hidden characters, delete empty rows and duplicates, then fit the columns.Changes data · backup onClean upFix numbers stored as textTurn numbers typed as text back into real numbers so totals and sorting work.Changes data · backup onClean upStandardize namesTrim spaces and capitalize each word in a column of names.Changes data · backup on