The Excluded sheet contains the dob, last name, and first name of people that should be excluded from the results
The submissions sheet contains the dob, last name and first name of people that should and should not be included in the results. The sheet also contains a submission date and code column.
The results sheet should contain the dob, last name, and first name of all people on the submissions sheet, that are not on the excluded sheet. When making the comparison, I only want to compare last name and date of birth.
I was able to get that working, however, I am ending up with some duplicates because there are legitimate duplicate rows in the submissions sheet that have the same last name and date of birth. I do not want to include the duplicate records in the results sheet.
Furthermore, I only want to include records from the submissions sheet that have a value of “abc” in the code field.
The sample sheet is here.
The submissions sheet contains the dob, last name and first name of people that should and should not be included in the results. The sheet also contains a submission date and code column.
The results sheet should contain the dob, last name, and first name of all people on the submissions sheet, that are not on the excluded sheet. When making the comparison, I only want to compare last name and date of birth.
I was able to get that working, however, I am ending up with some duplicates because there are legitimate duplicate rows in the submissions sheet that have the same last name and date of birth. I do not want to include the duplicate records in the results sheet.
Furthermore, I only want to include records from the submissions sheet that have a value of “abc” in the code field.
The sample sheet is here.