| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to compare two lists and identify cells with same numbers in | Excel Discussion (Misc queries) | |||
| How to compare two cells for the same numbers | Excel Worksheet Functions | |||
| Compare records in multiple sheet -> report | Excel Discussion (Misc queries) | |||
| How do I compare two lists of numbers? | Excel Worksheet Functions | |||
| Tool > Compare and Merge Workbooks... This is not a highlighted . | Excel Worksheet Functions | |||
Hybrid Mode
