Forum Discussion

Chloe_Apsey's avatar
Chloe_Apsey
Copper Contributor
May 17, 2022
Solved

Comparing two lists of Email Address and names and pulling the non-matching data to a new list

Hello,   I currently have an original list of participant's email who I contacted to take part in a study. I now have a second list of the emails of the participants who have taken part in the stud...
  • Lorenzo's avatar
    May 17, 2022

    Hi Chloe_Apsey 

     

    Assuming Excel 2021 or 365

     

     

    in E2:

    =FILTER(A2:A5, ISNA(XMATCH(A2:A5,C2:C3)))

Resources