Forum Discussion
Solved
Compare a responders column to distribution column and return those who did not respond
I have 2 columns of email addresses (responders, and full distribution) and I'm trying to create a 3rd column of emails for those who we are missing a response from. Capitalizations between the columns do not match.
I can easily compare using conditional formatting but the department needs a separate (easy to copy/paste into outlook) list to notify non compliant users.
Using =IF(COUNTIF($A:$A,B2)>0,,B2) I get either a 0 or the missing email, but can't filter out just to the missing emails. Any suggestions? Help? Places to look?
That could be
using
=TEXTJOIN(";",1,IF(LEN(B2:B100),IF(COUNTIF($A:$A,B2:B100),"",B2:B100),""))if to generate list of addresses to copy/paste into email client
2 Replies
That could be
using
=TEXTJOIN(";",1,IF(LEN(B2:B100),IF(COUNTIF($A:$A,B2:B100),"",B2:B100),""))if to generate list of addresses to copy/paste into email client
- That works perfectly and pulls them all into a single cell! Thank you very much.
Now, to figure out how to filter by a date and remove some invalid (user name doesn't match email so they get listed as MIA when they're not) entries!
