Forum Discussion

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...

excel

Lorenzo
May 17, 2022
Hi Chloe_Apsey

Assuming Excel 2021 or 365

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

Lorenzo

Silver Contributor

May 17, 2022

Hi Chloe_Apsey

Assuming Excel 2021 or 365

in E2:

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

Gr8lif
Copper Contributor
Mar 10, 2024
Thank you! Super easy formula and it worked!!!
- Lorenzo
  Silver Contributor
  Mar 11, 2024
  Gr8lif Similarly:
  =FILTER(A2:A5, COUNTIF(C2:C3,A2:A5) = 0)
Chloe_Apsey
Copper Contributor
May 17, 2022
Amazing - thank you very much!