Forum Discussion
Trying To Compare Two Worksheets For Duplicate Names
I have two worksheets in a workbook. Both worksheets consist of the alumni at a high school I work at. However, 1 worksheet has 600 more entries on it than the other. How can I compare both worksheets to find out which 600 names are missing from the the one worksheet? Thanks in advance!
1 Reply
You can use COUNTIFS to determine whether a name from one list is in the other list. Here's a simple example. The first argument should be the range of names in the other list, and the 2nd argument should be the name you're looking for. All the rows with 0 in column B are not in the other list.
