Hi, I'm trying to count how many time our newsletter subscribers don't respond by clicking or opening. I've downloaded the last 4 sends, loaded them into 1 sheet. Column A is unique email addresses all the way down, same for B, C, D. How can I count how many times a customer appears each of the columns? The columns are unequal in length.
Thanks for any help.
Do you have a full list of customers? If so, perhaps something like this?
Name Count List 1 List 2 List 3 List4 aa aa bb cc ff bb cc aa ff dd cc dd cc ee dd ff cc ee dd ff
B2=COUNTIF($C$2:$F$6,A2)
copied down.
If that does not work for you, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
hmm321 
Register To Reply
Bookmarks