2 files with email lists, need emails that don't appear in 1 file
- Thread starter Dimitri
- Start date
Well, I did some googling and found that there's a lot of sites that remove duplicates, trouble is, what they do is they'll remove only one instance of the two emails, leaving one. What I need is that when a duplicate is found remove both.
Anyone know something that can do that?
I found excel can remove duplicates, too, but, again, as described above.
Anyone know something that can do that?
I found excel can remove duplicates, too, but, again, as described above.
Just use Excel to remove the duplicates.
https://support.office.com/en-us/ar...e-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2
https://support.office.com/en-us/ar...e-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2
I've been fiddling with those kind of options in excel, but when I copy paste one of the lists from one file and then add it to the bottom of the other one in the other excel window, it behaves really strange.
For ex. if I tell it to sort it all (both of the lists, which are now one) it will sort it as two discrete lists, once one runs to z it will start with the other one beginning with a.
Then if I use conditional formatting to tell it to mark duplicates... well, I can't even understand WHAT the hell it does, but it doesn't highlight the duplicates.
For ex. if I tell it to sort it all (both of the lists, which are now one) it will sort it as two discrete lists, once one runs to z it will start with the other one beginning with a.
Then if I use conditional formatting to tell it to mark duplicates... well, I can't even understand WHAT the hell it does, but it doesn't highlight the duplicates.
Ok, I figured out why the list made up of the 2 lists acts so strange. Its because in one of the lists all the entries start with a blank space. So its a blank space and THEN whatever the email is.
So now to figure out how to delete that blank space from the beginning of 220 entries and then I can use the excel tricks to eliminate duplicates.
UPDATE:
Ok, I've managed to remove the initial blank spaces and now the list sorts properly, but the instructions posted above don't work because I'm in excel 2010. A lot of the instructions I find googling involve using conditional formatting to point out duplicates, but this seems to only point out one duplication and not the others.
UPDATE 2:
Well, I figured it out.
So now to figure out how to delete that blank space from the beginning of 220 entries and then I can use the excel tricks to eliminate duplicates.
UPDATE:
Ok, I've managed to remove the initial blank spaces and now the list sorts properly, but the instructions posted above don't work because I'm in excel 2010. A lot of the instructions I find googling involve using conditional formatting to point out duplicates, but this seems to only point out one duplication and not the others.
UPDATE 2:
Well, I figured it out.
Last edited: