I have an Excel sheet with names, emails. I also have a list of emails from a CMS and want to cross-reference. I want to remove all email addresses that are NOT on the CMS list from the Excel list. How would one go about doing this? I am a total newb in Excel. Thanks so much!
Just to clarify I sent out an email campaign and want to filter out all the emails that didn't take action. I have these email addresses from my CMS telling me which people clicked. So I want to take the original list that has way more details of the recipients and weed out the people that didn't respond. My thought is to cross-reference the email address and whichever ones are the same take that info and make a new list to import into Daylite.
Just to clarify I sent out an email campaign and want to filter out all the emails that didn't take action. I have these email addresses from my CMS telling me which people clicked. So I want to take the original list that has way more details of the recipients and weed out the people that didn't respond. My thought is to cross-reference the email address and whichever ones are the same take that info and make a new list to import into Daylite.
