how do I compare workbooks for duplicate data

M

mlarson47

I want to find duplicate entries in two different excel workbooks. I am
trying to eliminate the manual process of finding people who are not on the
2nd list, but are on the first one.
 
B

bj

one of the ways to do it
if your data is in column A in both workbooks
in B1 enter
=Countif([select the column in workbook2],A1)
copy this equation down to the bottom of your data.
Do autofilter on column B and select 0
this will be the names in Workbook 1 which are not in Workbook 2

one word of caution. the names must be exactly identical for this to work.
 
Top