I'm using Excel to track data on my company's email marketing. I have a master list of all my email contacts. I have lists of which email address opened each email we've sent out in the last few months.
Is there a simple way to sort the lists so that the rows line up matching content?
I'd like it to look like this:
Master...Email 1...Email 2...Email 3
Jim.........................Jim.........Jim
Misha....Misha
Alan
Jacquie.Jacquie...Jacquie...Jacquie
This way I'd know I should remove Alan from my list because he's never opened anything, and I should keep an eye on Misha because she only opened my first email.
Is there a series of commands that will do that, or should I resign myself to handling this manually?
Office 365, Excel for Windows 2010 & Excel for Mac
Posts
29,464
Re: List Management
Hi,
It's not clear, at least to me, exactly how your data looks and what you expect the result to look like.
Can you upload the actual workbook? A representative sample of the records will suffice if there are hundreds. In addition make sure you manually create the results for a section of your data so that we have something to test against.
I'm not sure if I can upload anything in this forum, I don't see any buttons for attachments.
For this problem, my data is all text.
Basically, I have a list of about 1000 people who signed up for our e-blasts. About 300-400 open any given email. We'd like to weed out the folks who aren't opening it, since our email client charges per contact.
I'm able to download a csv listing who opened each individual email from the server, and I'd like to cross check them against each other.
I have my columns set up as Master List, then Email 1, Email 2, Email 3, etc.
As I read across the columns, I'd like to be able to see the contact's name if he/she opened an email. So if Row 4 reads Jim, blank, blank, Jim, Jim, then I'll know that Jim didn't open the first 2 emails I sent out, but he did read 3 and 4.
Bookmarks