DAVID ADAMS
asked on
Can I delete matching data from 2 workshets and mark missing and duplicated entries
Hi
I have a workbook that has data in and im trying to delete data that matches on sheet 1 & 2. When I mean match I mean an exact match in columns A-D
What I need it to do is look at data in sheet 1 & 2 and as stated if a complete match I need it deleted. If missing from sheet 2 but in sheet 1 I need it to state "MISSING" in column E.
There will be occasions where data is duplicated in sheet 2. If this is the case and there is a match in sheet 1 I need it marked DUPLICATED but 1 entry deleting as its a exact match.
The enclosed workbook gives you some sort of idea what I mean.
Book1.xlsx
I have a workbook that has data in and im trying to delete data that matches on sheet 1 & 2. When I mean match I mean an exact match in columns A-D
What I need it to do is look at data in sheet 1 & 2 and as stated if a complete match I need it deleted. If missing from sheet 2 but in sheet 1 I need it to state "MISSING" in column E.
There will be occasions where data is duplicated in sheet 2. If this is the case and there is a match in sheet 1 I need it marked DUPLICATED but 1 entry deleting as its a exact match.
The enclosed workbook gives you some sort of idea what I mean.
Book1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome David!
ASKER