how do I compare workbooks for duplicate data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing Duplicates to another sheet 1
Delete duplicates on 2nd workbook 4
how to find duplicate entry in one sheet and in workbook 1
Excel Comparing two columns 1
how do I find duplicate information on 2 sheets using a formula? 1
Merge Multiple workbook sheets into one workbook 0
Duplicates 2
How can I compare spreadsheets and remove duplicated data? 3

Back
Top