need to compare id numbers of records in 2 workbooks

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

Guest

I need to take a spreadsheet in one workbook and compare the record id
numbers in another workbook. I ultimately want excel to tell me which
records are missing and how many. Any clues?
 
1. open a new worksheet
2. copy the master ID list (the complete list) to column B of the new
worksheet
3. copy the sample list to column A of the new worksheet
4. in C1, enter:
=IF(COUNTIF(A:A,B1)=0,1,0) and copy down as far as teh data in column B

A "1" in column C marks the items in column B that are missing from column A.


Sum column C to get the total number missing
 
That worked great thanks and it sort of identified what I needed to do in
reverse to see which ones were missing so thanks very much for that.
 

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

Excel Compare numbers on 1 tab to other tabs in workbook. 1
Access Compare records in same access table 0
View 2 workbooks to compare 1
Comparing 2 worksheets in Excel 2007 1
Compare two workbooks and hi-light matches 0
Comparing and removing data in different workbooks 3
comparing two worksheets 1
move worksheet to end of another workbook 3

Back
Top