Forum Discussion
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...
=IF(ISNUMBER(MATCH(A2,$B$2:$B$8,0))=FALSE,A2,"")An alternative for older versions of excel could be this formula.