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?
Bookmarks