+ 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 - RIP 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,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.

    Rgds
    Richard Buttrey

    RIP - d. 06/10/2022

    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: 

  4. #4
    Forum Moderator - RIP 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,464

    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