+ Reply to Thread
Results 1 to 4 of 4

List Management

  1. #1
    Registered User
    Join Date
    08-16-2010
    Location
    Union, NJ
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    2

    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?

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,406

    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.

    Rgds
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    08-16-2010
    Location
    Union, NJ
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    2

    Re: List Management

    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: 
    <table border=1><tbody><tr><td>Master</td><td>Email 1</td><td>Email 2</td><td>Email 3</td><td>Email 4</td></tr>
    <tr><td>Jim</td><td></td><td>Jim</td><td>Jim</td><td>Jim</td></tr>
    <tr><td>Misha</td><td>Misha</td><td></td><td></td><td></td></tr>
    <tr><td>Alan</td><td></td><td></td><td></td><td></td></tr>
    <tr><td>Jacquie</td><td>Jacquie</td><td></td><td>Jacquie</td><td>Jacquie</td></tr>
    </tbody></table>

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,406

    Re: List Management

    Hi,

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

    Rgds

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1