r/excel • u/Monstrosatee • 17h ago

Comparing two data sets. solved

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 🙏

1 Upvotes

100% Upvoted

5 comments sorted by

View all comments

1

u/HappierThan 1063 15h ago

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.