Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare workbooks
I have two workbooks which contains a list of names, id, issues- multiple
type of issues in this column, master record date, issue begin date and issue end date . One workbook contains only records with a specific issue end date (A) and the other contains records with issue dates the specific issue end date (B). I need to distinguish the name/id of people who have the specific issue in A who do not have a record for the specific issue in B. example Sally Smith has Issue 1 enddate in workbook A, but does not have an issue start date for Issue 1 in workbook B Is there an easy way to compare these? I am currently trying to match the records by hand but there are 4000 records in each workbook. Thank you in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare workbooks
Par,
One of the easiest methods is to make unique keys or lookups and then use the sumif and if it is 0 then there is no issue. I don't quite understand exact format of the workbooks so it is a little difficult to gove an example. -- HTHs Martin "PAR" wrote: I have two workbooks which contains a list of names, id, issues- multiple type of issues in this column, master record date, issue begin date and issue end date . One workbook contains only records with a specific issue end date (A) and the other contains records with issue dates the specific issue end date (B). I need to distinguish the name/id of people who have the specific issue in A who do not have a record for the specific issue in B. example Sally Smith has Issue 1 enddate in workbook A, but does not have an issue start date for Issue 1 in workbook B Is there an easy way to compare these? I am currently trying to match the records by hand but there are 4000 records in each workbook. Thank you in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare workbooks
Hard to be very specific, but
in workbook A in the next available column =Sumproduct(--(B!$A$1:$A$4000=A1),--(B!$C$1:$C$4000=C1),--(B!$E$1:$E$4000<E1 )) Column A is a name or id identifier, Column C is an issue identifier and Column E is the date. This is a general concept which you will need to adapt to your situation. It will return the count of records in B meeting the conditions for the row containing the formula. You then drag fill this down the column. -- Regards, Tom Ogilvy "PAR" wrote in message ... I have two workbooks which contains a list of names, id, issues- multiple type of issues in this column, master record date, issue begin date and issue end date . One workbook contains only records with a specific issue end date (A) and the other contains records with issue dates the specific issue end date (B). I need to distinguish the name/id of people who have the specific issue in A who do not have a record for the specific issue in B. example Sally Smith has Issue 1 enddate in workbook A, but does not have an issue start date for Issue 1 in workbook B Is there an easy way to compare these? I am currently trying to match the records by hand but there are 4000 records in each workbook. Thank you in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare workbooks | Excel Discussion (Misc queries) | |||
Compare workbooks | Excel Discussion (Misc queries) | |||
compare different workbooks | Excel Worksheet Functions | |||
COMPARE 2 WORKBOOKS | Excel Programming | |||
Compare 2 different workbooks with the result in a 3rd | Excel Discussion (Misc queries) |