need to compare id numbers of records in 2 workbooks

T

Teaky

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?
 
G

Gary''s Student

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
 
T

Teaky

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.
 
Top