Forum Discussion
Email Sent Frequency
Hi all,
I am looking into email frequency.
I have exported data that showcases the email addresses that have had an email sent to them, i need to showcase how many times each email address was emailed by a user.
I have looked into multiple formula options including COUNTIFS and FREQUENCY but all require a reference to measure against, and as i don't know how many times these email addresses have been used nor do i know what the threshold would be i'm not too sure how to measure this.
Any advice would be great! 🙂
2 Replies
I don't know if this is exactly what you were looking for, but:
Please see attached document with proposed solution.
One possibility is to use UNIQUE function to get the list of unique email addresses and then use COUNTIF next to them to get the number of times these appear in the full list.
- Hi Martin - thank you so much for your quick reply, i'll give this a try! 🙂
