I need to delete duplicates inside of spreadsheet

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I have an email database that has duplicate entries and I need to know how to
search them and delete duplicates. Then I need to merge 2 different
spreadsheets together.

Help!!!
 
Hi,
Copy and paste all the email addresses into one list.
Select the first cell in the list.
From the Data menu, select Filter > Advanced Filter.
In the advanced filter window:
Check the "Copy to another location" thingy,
Tick Unique records only thingy,
In the Copy to field, enter the start cell for where you want the list of
uniques to go
OK
Unique items are now listed in a new place, and you can delete your original
list.
Regards - Dave.
 
Back
Top