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