Hi,
We have downloaded a list of names who have been sent 4 articles on an email campaign, and their engagement (i.e. clicked on) the articles These are formatted in the following way, with data underneath each heading:
Article 1
Name (column A)
Email Add (column B)
Handler (column C)
Article 2
Name (Column E)
Email Add (Column F)
Handler (Column G)
Article 3
Name (Column I)
Email Add (Column J)
Handler (Column K)
Article 4
Name (Column M)
Email Add (Column N)
Handler (Column O)
There is a repetition of certain names in columns A, E,I and M - and as such i'd like to know who has been the most engaged in the articles i.e. their name appears in more than one column, and a formula to return that name and number of times mentioned.
So in theory, there will be some people that have read 4 articles, some 3 - and i'd like a list of who they are based on the number of times their name appears.
Thanks
Jack
We have downloaded a list of names who have been sent 4 articles on an email campaign, and their engagement (i.e. clicked on) the articles These are formatted in the following way, with data underneath each heading:
Article 1
Name (column A)
Email Add (column B)
Handler (column C)
Article 2
Name (Column E)
Email Add (Column F)
Handler (Column G)
Article 3
Name (Column I)
Email Add (Column J)
Handler (Column K)
Article 4
Name (Column M)
Email Add (Column N)
Handler (Column O)
There is a repetition of certain names in columns A, E,I and M - and as such i'd like to know who has been the most engaged in the articles i.e. their name appears in more than one column, and a formula to return that name and number of times mentioned.
So in theory, there will be some people that have read 4 articles, some 3 - and i'd like a list of who they are based on the number of times their name appears.
Thanks
Jack