As I was importing my list to MailChimp (Powered by MailChimp) I found my excel lists to be unbearable. I never thought organizing an email list could be this TEDIOUS! I've spend two whole days just looking for duplicates and makign sure to filter out the spam emails like email@example.com or the countless number of firstname.lastname@example.org type of emails. I thought i had culled it down to a manageable 1000 but as i run this find duplicate script in excel my list was reduced to a not very encouraging 500.
here's a link to Microsoft's very own guide to find duplicates on excel!
Method 1: Use a worksheet formulaTo use a worksheet formula to compare the data in two columns, follow these steps:
|2.||In a new worksheet, enter the following data (leave column B empty):|
A1: 1 B1: C1: 3
|3.||Type the following formula in cell B1:|