Sorry for what is probably silly newbie question. I have a mailing list with 8000 email addresses, and I want to remove all email addresses who have not opened an email in last 8 newsletters sent to reduce to only those who actively read the email.
I have column A containing 8000 email addresses, and columns b, c, d, e , f, g, h, i, j, which contain the email addresses of those that have opened various newsletters. I removed duplicate entries from within each individual column and need to compare duplicate entries between column a and b-j to then delete from column A all entries which are not in at least one (or more) of columns b-j.
eg
column a b c d
bob@bob.com jane@jane.com bob@bob.com jane@bob.com
ruth@ruth.com
doris@doris.com
jane@jane.com bob@bob.com
in this case I would want to remove ruth and doris since they do not exist in any of the other columns so then column A will end up representing a trimmed down active list.
Is there a simple formula to do this, thanks,
I have column A containing 8000 email addresses, and columns b, c, d, e , f, g, h, i, j, which contain the email addresses of those that have opened various newsletters. I removed duplicate entries from within each individual column and need to compare duplicate entries between column a and b-j to then delete from column A all entries which are not in at least one (or more) of columns b-j.
eg
column a b c d
bob@bob.com jane@jane.com bob@bob.com jane@bob.com
ruth@ruth.com
doris@doris.com
jane@jane.com bob@bob.com
in this case I would want to remove ruth and doris since they do not exist in any of the other columns so then column A will end up representing a trimmed down active list.
Is there a simple formula to do this, thanks,