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/AutoModerator]

/u/Monstrosatee - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[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}

[u/HappierThan]

In a spare column on small list =COUNTIF(Sheet2!$A$2:$A$2588,A2) and filldown to Row 1934

Filter on that column for 0.