Comparing two data sets.

[u/Monstrosatee]

Hey guys, new here.

Hoping someone has an easy to understand way of doing this, I’m not great at excel!

I have two worksheets, one has 1933 rows of email address in it, and one has 2587 rows. Not each row in this sheet has an email address in it. Many of the email addresses will match across both sheets but won’t be in the same row in their respective sheet.

I need to somehow compare the two columns of email addresses, to see how many of the 1933 emails are no longer included in the 2587 email addresses. Does that make sense?

Thank you in advance 🙏

[u/caribou16]

Make a new column next to the addresses in the shorter list. In that column, use a formula that checks the longer list if the address directly to the left is present, copy that down the column.

Something like =IF(COUNTIF(D:D,A2)>0, "Yes","No") assumes the short list is in column A, the long list is in column D and returns yes or no is a match is found.

[u/Monstrosatee → u/caribou16]

Solution verified thank you

[u/reputatorbot → u/Monstrosatee]

You have awarded 1 point to caribou16.

---

^{I am a bot - please contact the mods with any questions}