need to compare id numbers of records in 2 workbooks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Teaky - 23 Aug 2006 14:38 GMT

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?

Reply to this Message

Gary''s Student - 23 Aug 2006 16:21 GMT

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

Signature

Gary's Student

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

Reply to this Message

Teaky - 23 Aug 2006 17:49 GMT

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.

> 1. open a new worksheet
> 2. copy the master ID list (the complete list) to column B of the new
[quoted text clipped - 10 lines]
> > numbers in another workbook. I ultimately want excel to tell me which
> > records are missing and how many. Any clues?

Reply to this Message