need to compare id numbers of records in 2 workbooks
 

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?

need to compare id numbers of records in 2 workbooks
 

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

--
Gary's Student


"Teaky" wrote:

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?

need to compare id numbers of records in 2 workbooks
 

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.

"Gary''s Student" wrote:

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

--
Gary's Student


"Teaky" wrote:

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?