List Management

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?

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.

Rgds

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.

Does that make more sense?

I'll try HTML, too.

HTML Code: 

Hi,

The button for attachments is in the Additional options section just below the 'Submit Reply' button.

Rgds