Quickly removing do not mail names on a mailing list

[unicyclejunkie]

I am trying to find out how to quickly remove do not mail names from our mailing lists. We have several lists and our do not mail list is huge(280) so it's getting very time consuming to clean the lists. I'm assuming I can copy the do not mail list names to the current mailing list and then remove duplicates..but I want to remove both duplicates when i do that. My understanding of the remove duplicates feature and unique values is already a bit foggy. If someone could give me a step by step process on how to do this it'd be greatly appreciated. It's way too time consuming to search for each name from the do not mail list :p

[alansidman]

I suggest you upload a sample of your data for analysis. It will be easier to provide you with a solution with data that resembles your workbook.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[unicyclejunkie]

Ok so sample 1 is the do not call list(which is actually 280 names) and sample 2 would be the actual mailing list which is usually 10,000+. I want to be able to copy the do not mail list to the mailing list, remove BOTH duplicates and then delete the do not mail names that were copied. In this case Chelsea Humphrey. I should add, I don't know if this is the best way to do this either...could there be a better way?

[unicyclejunkie]

Any ideas on this?

[alansidman]

I see the simplest way to do this:

In sample1, in G2, type =B2&" "&A2 and copy down
In sample2, in G1, type =B1&" "&A1 and copy down

In sample2, in H1, type =MATCH(G1,[Sample1.xlsx]Sheet1!$G$2:$G$11,0) and copy down.

If in Column H, you have anything other than #N/A, it indicates that the item is on the Do Not Call list. Sort the list and delete all rows that are not #N/A

Alan

[unicyclejunkie]

Thank you very much. I got it working on the sample ones attatched..but now I can't seem to get it working on the actual lists. I even tried copying the addresses to column G and trying it that way and there was definitely duplicates that weren't being shown. I renamed the lists to sample1 and sample2 because I'm assuming the filename in the brackets should be the same as the filename..

[alansidman]

The name in brackets is in fact the file name. Can you expand on what is happening that is not working? Difficult to analyze without you providing additional information. Your current explanation offers no clues as to the issues. If you mimic the formulas I provided, it should work for you.