Remove Duplicate Email Addresses

Does anyone know how to remove duplicate email addresses from either excel or word?

I would like to send our customers a newsletter but not aggravate them by not filtering out their email addresses which appear more then once in our database. Any suggestions?

I would suggest adding a dummy column next to your column with email addresses and doing a formula that looks similar to this

=IF(COUNTIF($A$2:$A2,$A2)>1,"Duplicate","")

Then you can filter by duplicates and delete them out.

I'm sorry, but could you please elaborate on how this is done step by step?

It will count the number of times the value shows up in the range. If it shows up more than once it will write "duplicate" in the cell. Then you can sort the list by that column and all the duplicates will show up together. Change the value in the range to represent your actual range.

Originally Posted by wirelessimports

Does anyone know how to remove duplicate email addresses from either excel or word?

I would like to send our customers a newsletter but not aggravate them by not filtering out their email addresses which appear more then once in our database. Any suggestions?

Select your range > Data > Filter > Advanced Filter > select Copy to another location > List range: your range > Copy to: select any blank cell > tick on Unique records only > OK

Hello Sir,
I am expert in excel and can remove the email duplicates and send it back to you. Please mail your file to [email protected].

Cheers,
Rajashekar

Originally Posted by wirelessimports

Does anyone know how to remove duplicate email addresses from either excel or word?

I would like to send our customers a newsletter but not aggravate them by not filtering out their email addresses which appear more then once in our database. Any suggestions?