Jun 27 2019 12:10 AM - edited Jun 27 2019 12:16 AM
What is the formula for matching values in two columns. the email address matching data should be listed in column C and D, please see attached excel file.
- Target email not in actual email
- actual email not in target email
Jun 27 2019 01:46 AM
Hey Marvin
Try this:
* I used the IF formula and the SUMPRODUCT formula to try and solve the problem
Jun 27 2019 02:03 AM
In the attached file, the formula in C2, copied down rows, is:
=IF(COUNTIF(B:B,A2),
"No","Yes")
Conversely, the formula in D2, copied down rows, is:
=IF(COUNTIF(A:A,B2),
"No","Yes")
Jun 27 2019 02:04 AM - edited Jun 27 2019 02:04 AM