I have an email list with 16,000+ (A) emails in it (one column). Some are duplicates. I need the formula to find and eliminate the duplicates. I want to save one copy of each duplicate.
A separate but related matter:
I also have another column of emails probably 2000+ (B). I need to find and delete the emails that show up in column A and B.
Thank you for your help.
Last edited by garrettw731; 09-10-2012 at 01:26 PM.
Are there emails that are not considered duplicates that have the same Subject Title?
Suggest
=COUNTIF(A:A,A1) in B1
to identify rows that are replicated.
=COUNTIF(A:A,B1) in C1
will identify entries which occur in columns A and B.
Martin
Some of the emails may appear 30 or 40 times. Some may only show up 2 times. I just need to have each email appear only once in the list.
Have you tried the Remove Duplicates on the Data ribbon?
There's a similar question here: http://www.excelforum.com/excel-form...eadsheets.html which you might not have found when searching the forum before posting - I think you'll find it helpful.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks