Removing Duplicates (Advanced)

[mphillips]

Hello --

Attached is a workbook that has two different tabs in which I need help removing duplicates, both based on different criteria.

Tab "Example1" :
I want column D to say "Keep" if B=C
I want column D to say "Keep" if B is Blank and C has a date


Tab "Example2":
There are duplicate values here based on column A
If B is Blank and C has a date, keep that row and remove the other rows associated to that same unique key in column A
If both B and C has a date, delete rows associated to those with the same matching unique key in column A

Attached is the example.

[oeldere]

e2 = if(OR(B2=C2,and(B2="",(year(C2)>0)=true)),"keep","remove") and drag down.

[mphillips]

Thank you! That helped with the first tab, but not the second.

[mphillips]

I've got the below:

=IF(AND(B7="",(YEAR(C7)>0)),"Keep",IF(B7=C7,"Remove","Keep"))

But needs to take into consideration the other rows associated to the same unique key

[oeldere]

In that case you need to explain more.

Color the related cells and put the desired (expected) result in your excel file.