Forum Discussion

cwales's avatar
cwales
Copper Contributor
Jun 09, 2020
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 colu...
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 10, 2020

    cwales 

    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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 10, 2020

cwales 

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

cwales's avatar
cwales
Copper Contributor
Jun 10, 2020
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!

Resources